第一种:
SELECT
COUNT(*)
FROM Hais_20170509.dbo.Sxzx_V_BBFData_Tmp
LEFT JOIN KangDR.dbo.v_Item_Department vid
ON vid.FName=DeptName AND vid.FCategoryID=26000
第二种:
SELECT
COUNT(*)
FROM Hais_20170509.dbo.Sxzx_V_BBFData_Tmp
LEFT JOIN KangDR.dbo.v_Item_Department vid
ON vid.FName=DeptName
WHERE vid.FCategoryID=26000
第一种作用范围是表vid,第二种的作用范围是inner join后的结果集