select iRecord,ord,count(DISTINCT iRecord) from(select top 1000 iRecord,0 as ord from tblBoardRecord_1800000121_41 Where idCorp=1800000121 and iProject=41 and (field8 like '%Sichuan%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_41 Where idCorp=1800000121 and iProject=41 and (field2 like '%Sichuan%')) a where irecord<>0 group by iRecord,ord order by ord asc,iRecord desc
Invest in China
Homepage |
首页 新闻动态 法律服务 数据服务 项目服务 投资环境 投资服务机构 经济开发区
China Macro Economy Investment Environment | China Investment Environment by regions
Home >Investment Environment >
Search
Sichuan
1 results   Page 1 of 1  First Previous 1 Next Last
Inward Investment Project More>>
Invest in China Serials
 Site Map | About Us | Services | Links | Statement

Ministry of Commerce of the People's Republic of China Department of Foreign Investment Administration

Operated by Investment Promotion Agency of MOFCOM

Tel:  (86-10) 64404554

Copyright by Invest in China

Fax: (86-10) 64515317

ICP Record No.: Beijing ICP 06041048-4 E-mail: service@fdi.gov.cn