select * from table1 where 公司名称 like '%杭州%' select * from table1 where 公司名称 like '%义乌%'
算了 自己解决了SELECT COUNT(CID) AS IDNUM, cmpname FROM Company GROUP BY cmpname IDNUM>1 的里面再把所有名称记录下来 ssid=ssid+"," +dr[cmpname].ToString(); 然后 select * from CRM_Company where cmpname in ('+ssid+') order by cmpname
select * from table1 where 公司名称 like '%义乌%'
IDNUM>1 的里面再把所有名称记录下来 ssid=ssid+","
+dr[cmpname].ToString();
然后
select * from CRM_Company where cmpname in ('+ssid+') order by cmpname