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
分组看一下 各自的数量