select goodsid,goodsname,shopid,wlbs
from nbo_stock  where dhbs not like  '暂停订货' and shopid in ('012027','012022','012122','012011','012020','012045','012051',
'012036','012015','012065','012033','012028','012016','012082','012030','012106','012110','012029','012060',
'012075','012124','012123','012063','012053','012035','012024','012104','012002','012095','012116','012039',
'012100','012023','012064','012089','012017','012010','012119','012094','012041','012066','012055','012012',
'012109','012085','012114','012135','012146','012134','012129','012144','012141','012131','012149','012151',
'012127','012043','012044','012148','012138''012092','012088','012111','012073')
这条语句没问题，但我想知道nbo_stock  这个表中'012027','012022','012122','012011','012020','012045','012051',
'012036','012015','012065','012033','012028','012016','012082','012030','012106','012110','012029','012060',
'012075','012124','012123','012063','012053','012035','012024','012104','012002','012095','012116','012039',
'012100','012023','012064','012089','012017','012010','012119','012094','012041','012066','012055','012012',
'012109','012085','012114','012135','012146','012134','012129','012144','012141','012131','012149','012151',
'012127','012043','012044','012148','012138''012092','012088','012111','012073'些数组出现了多少次应该怎么去写语法？

放在一个单独的表中，该表可以只有一个字段，然后用：... and shopid in （select ?? from XX）

select count(shopid) from nbo_stock where shopid='012027'

查不出啊

select count(shopid) from nbo_stock where shopid in（select ?? from XX）

OK解决，谢谢！