摘要:
嵌套更新|更新产品所对应的公司分类 update ProContent set Fid=(select Fid from companys where C_ID=ProContent.C_ID),Sid=(select Sid from companys where C_ID=ProContent.C_ID),Tid=(select Tid from companys where C_ID=Pro... 阅读全文
摘要:
查看公司和公司产品数的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','... 阅读全文