SELECT A.uID, count(CASE A.cSex WHEN '男' THEN 1 ELSE 0 END) as dNum FROM A left OUTER JOIN
(select B.uID ,B.cEmpNamef from B )T2 ON A.uID = T2.uID
WHERE T2.cEmpNamef IS NOT NULL AND A.cSex='男'
GROUP BY A.uID
(select B.uID ,B.cEmpNamef from B )T2 ON A.uID = T2.uID
WHERE T2.cEmpNamef IS NOT NULL AND A.cSex='男'
GROUP BY A.uID
可是这样写也是不行的。得不到我要的结果。