- - Select Company - - 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_shortAGILE PROPERTY (03383)AGTECH HOLDINGS (08279)AIR CHINA (00753)AMBER ENERGY (00090)ANTA SPORTS (02020)ARTEL GROUP (00931)ARTINI (00789)ASIA ENERGY (00351)BEIJING ENT (00392)BESUNYEN (00926)BIOSINO BIO-TEC (08247)BJ PROPERTIES (00925)BLOOMAGE BIOTEC (00963)BLUE ADISSEO (01095)BOSHIWA INT'L (01698)BRIGHTOIL (00933)BURWILL (00024)BYD COMPANY (01211)C HIGHPRECISION (00591)C PUBLIC HEALTH (08116)CDAYENONFER (00661)CH ALL ACCESS (00633)CH AUTOMATION (00569)CH AUTOSYSTEM (01283)CH FIN LEASING (02312)CH FORTUNE GP (00290)CH RONGSHENG (01101)CHALCO (02600)CHANGFENG AXLE (01039)CHAOWEI POWER (00951)CHINA COAL (01898)CHINA COMM CONS (01800)CHINA COSCO (01919)CHINA EB INT'L (00257)CHINA ENERGINE (01185)CHINA ENERGY (00228)CHINA FORESTRY (00930)CHINA GREEN (00904)CHINA MOTION (00989)CHINA ORIENTAL (00581)CHINA RAIL CONS (01186)CHINA STARCH (03838)CHINA UNICOM (00762)CHINA WATER (00855)CHINAVTM MINING (00893)CHINESE EST H (00127)CHU KONG PIPE (01938)CHU KONG SHIP (00560)CINDA INTL HLDG (00111)CITIC BANK (00998)CJ LAND (00957)CLEAR MEDIA (00100)CM BANK (03968)CMOC (03993)CNOOC (00883)COFCO PACKAGING (00906)COME SURE GROUP (00794)COSCO PACIFIC (01199)COSTIN NEW MAT (02228)CQRC BANK (03618)CREDIT CHINA (08207)CT HOLDINGS (01008)DEJIN RES (01163)DIGITAL CHINA (00861)EFORCE HOLDINGS (00943)FAR EAST GLOBAL (00830)FORTE (02337)FRANSHION PPT (00817)FUSHAN ENERGY (00639)FUTONG TECH (00465)GCL-POLY ENERGY (03800)GLOBAL BIO-CHEM (00809)GLOBAL SWEET (03889)GUOJIN RES (00630)HAO TIAN RES GP (00474)HENRY GROUP (00859)HK ENERGY HOLD (00987)HKC (HOLDINGS) (00190)HKRH (02882)HONTEX INT'L (00946)HUA HAN (00587)HUABAO INTL (00336)HUADIAN POWER (01071)IMERCHANTS (08009)KING STONE ENGY (00663)KINGWELL GROUP (01195)LI NING (02331)LITTLE SHEEP (00968)LO'S ENVIRO-PRO (00309)LONKING (03339)LUKS GROUP (VN) (00366)MAGIC HOLDINGS (01633)MAN WAH HLDGS (01999)MENGNIU DAIRY (02319)MIN RESOURCES (01208)MOBI DEV (00947)NEW ENV ENERGY (03989)NEWAY GROUP (00055)NORSTAR (02339)O-NET COMM GP (00877)PACIFIC ANDES (01174)PEAK SPORT (01968)PING AN (02318)PROSPERITY INTL (00803)PROSTEN TECH (08026)QJY MEDIA (02366)RAYMOND IND (00229)RCG (00802)ROYALE FURN (01198)RUINIAN (02010)SA SA INT'L (00178)SCUD GROUP (01399)SHANGHAI PRIME (02345)SHENGLI PIPE (01080)SHENGUAN HLDGS (00829)SHINEWAY PHARM (02877)SIJIA GROUP (01863)SIM TECH (02000)SINGYES SOLAR (00750)SINO DRAGON-NEW (00395)SINOFERT (00297)SINOPEC CORP (00386)SINOPHARM (01099)SINOREF HLDGS (01020)SINOTRUK (03808)SKYWORTH DIGITAL (00751)SOUND GLOBAL (00967)SOUNDWILL HOLD (00878)SUN.KING ELEC (00580)SUNDART INT'L (02288)SUSTAIN FOREST (00723)TAK SING ALLI (00126)TC INTERCONNECT (00515)TCC INT'L HOLD (01136)TENCENT (00700)TIANNENG POWER (00819)TIME INFRA HOLD (00686)TONTINE WINES (00389)TPV TECHNOLOGY (00903)TRAVELSKY TECH (00696)TSC OFFSHORE (00206)VODONE (00082)WARDERLY (00607)WASION GROUP (03393)WATER INDUSTRY (01129)WEIQIAO TEXTILE (02698)WELLING HOLDING (00382)WINFAIR INV (00287)WING LEE HOLD (00876)WINSWAY (01733)XINGYE COPPER (00505)XINYI GLASS (00868)XTEP INT'L (01368)YARDWAY (00646)YASHILI (01230)YINGDE GASES (02168)YOUYUAN HLDGS (02268)YURUN FOOD (01068)YUZHOU PPT (01628)ZHONGAN REALEST (00672)