- - Select - - View all SELECT client_infoen.clientname_short, client_info.code FROM client_infoen, client_info where client_info.status='A' and client_infoen.clientid in (select clientid from function1 where function1.status='Y') and client_infoen.clientid = client_info.clientid order by clientname_shortAIR CHINA (00753)AMBER ENERGY (00090)ANTA SPORTS (02020)ARTINI (00789)BEIJING ENT (00392)BIOSINO BIO-TEC (08247)BJ PROPERTIES (00925)BLOOMAGE BIOTEC (00963)BRIGHTOIL (00933)BURWILL (00024)BYD COMPANY (01211)C HIGHPRECISION (00591)CDAYENONFER (00661)CENTURY LEGEND (00079)CH ALL ACCESS (00633)CH AUTOMATION (00569)CH FIN LEASING (02312)CHALCO (02600)CHINA COAL (01898)CHINA COMM CONS (01800)CHINA COSCO (01919)CHINA EB INT'L (00257)CHINA ENERGY (00228)CHINA GREEN (00904)CHINA MOTION (00989)CHINA ORIENTAL (00581)CHINA RAIL CONS (01186)CHINA STARCH (03838)CHINA TRENDS (08171)CHINA UNICOM (00762)CHINA WATER (00855)CHINA XLX FERT (01866)CHINAVTM MINING (00893)CHINESE EST H (00127)CHU KONG SHIP (00560)CINDA INTL HLDG (00111)CITIC BANK (00998)CLEAR MEDIA (00100)CM BANK (03968)CMOC (03993)COSCO PACIFIC (01199)CT HOLDINGS (01008)DIGITAL CHINA (00861)EFORCE HOLDINGS (00943)FORTE (02337)FRANSHION PPT (00817)FUSHAN ENERGY (00639)GCL-POLY ENERGY (03800)GLOBAL BIO-CHEM (00809)GLOBAL RES DEV (08116)GLOBAL SWEET (03889)HENRY GROUP (00859)HONTEX INT'L (00946)HUA HAN (00587)HUABAO INTL (00336)HUADIAN POWER (01071)IMERCHANTS (08009)LI NING (02331)LITTLE SHEEP (00968)LUKS GROUP (VN) (00366)MEDIACHINA CORP (00419)MENGNIU DAIRY (02319)MIN RESOURCES (01208)MOBI DEV (00947)NEWTIMES ENERGY (00166)NORSTAR (02339)PACIFIC ANDES (01174)PING AN (02318)PROSPERITY INTL (00803)PROSTEN TECH (08026)QJY MEDIA (02366)RAYMOND IND (00229)ROYALE FURN (01198)SA SA INT'L (00178)SCUD GROUP (01399)SHANGHAI PRIME (02345)SHENGLI PIPE (01080)SHINEWAY PHARM (02877)SIM TECH (02000)SINO DRAGON-NEW (00395)SINOFERT (00297)SINOPEC CORP (00386)SINOPHARM (01099)SINOTRUK (03808)SKYWORTH DIGITAL (00751)SOUNDWILL HOLD (00878)SUNAC (01918)SUNDART INT'L (02288)TAK SING ALLI (00126)TCC INT'L HOLD (01136)TENCENT (00700)TIANNENG POWER (00819)TONTINE WINES (00389)TPV TECHNOLOGY (00903)VODONE (00082)WARDERLY (00607)WASION GROUP (03393)WATER INDUSTRY (01129)WEIQIAO TEXTILE (02698)WELLING HOLDING (00382)WINFAIR INV (00287)WING LEE HOLD (00876)XTEP INT'L (01368)YINGDE GASES (02168)YURUN FOOD (01068)YUZHOU PPT (01628)ZHONGAN REALEST (00672)