帮我看看这句SQL为什么不好用
SELECT count(*) as num FROM HIS_User where JobType= '1 ' and CompanyID in (select CompanyID from HIS_Company where CompanyType= '1 ')
[解决办法]
SELECT count(1) as num FROM HIS_User where JobType= '1 ' and CompanyID in (select CompanyID from HIS_Company where CompanyType= '1 ')
[解决办法]
加
group by JobType,CompanyID
分组看一下 各自的数量