- - 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 FORESTRY (00930)CHINA GREEN (00904)CHINA MOTION (00989)CHINA ORIENTAL (00581)CHINA PUBLIC HEALTHCARE (08116)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 PIPE (01938)CHU KONG SHIP (00560)CINDA INTL HLDG (00111)CITIC BANK (00998)CLEAR MEDIA (00100)CM BANK (03968)CMOC (03993)CNOOC (00883)COSCO PACIFIC (01199)CT HOLDINGS (01008)DIGITAL CHINA (00861)EFORCE HOLDINGS (00943)FORTE (02337)FRANSHION PPT (00817)FUSHAN ENERGY (00639)FUTONG TECH (00465)GCL-POLY ENERGY (03800)GLOBAL BIO-CHEM (00809)GLOBAL SWEET (03889)HENRY GROUP (00859)HKC (HOLDINGS) (00190)HONTEX INT'L (00946)HUA HAN (00587)HUABAO INTL (00336)HUADIAN POWER (01071)IMERCHANTS (08009)JACKIN INT'L (00630)KING STONE ENGY (00663)LI NING (02331)LITTLE SHEEP (00968)LO'S ENVIRO-PRO (00309)LONKING (03339)LUKS GROUP (VN) (00366)MEDIACHINA CORP (00419)MENGNIU DAIRY (02319)MIN RESOURCES (01208)MOBI DEV (00947)NEWAY GROUP (00055)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)RUINIAN (02010)SA SA INT'L (00178)SCUD GROUP (01399)SHANGHAI PRIME (02345)SHENGLI PIPE (01080)SHINEWAY PHARM (02877)SIJIA GROUP (01863)SIM TECH (02000)SINO DRAGON-NEW (00395)SINOFERT (00297)SINOPEC CORP (00386)SINOPHARM (01099)SINOTRUK (03808)SKYWORTH DIGITAL (00751)SMARTONE TELE (00315)SOUNDWILL HOLD (00878)SUNAC (01918)SUNDART INT'L (02288)SUSTAIN FOREST (00723)TAK SING ALLI (00126)TCC INT'L HOLD (01136)TENCENT (00700)TIANNENG POWER (00819)TONTINE WINES (00389)TPV TECHNOLOGY (00903)TRAVELSKY TECH (00696)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)