查看公司和公司产品数的sql语句

查看公司和公司产品数的sql语句

select * from (select C_ID,(select count(1) from product where C_ID=companyinfo.C_ID) c from companyinfo where C_ID in(select C_ID from EnterpriseLibrary where FirstSort in('32d670','6a726a','0796ce','74f0cb','9671cf','70b5bd','b2130b','6f70b0','916dc2','67235c'))) tableCompany where c>0