SELECT
COUNT(*) AS fNUM
,'0' fSUM
,P.FDWID AS fOwerOrgID
FROM
ECON_Proj_MultiBusiness S
LEFT JOIN BC_MT_Project P
ON P.FID = S.fProjectID
WHERE
S.fState = '在施'
GROUP BY
P.FDWID
UNION ALL
SELECT
'0' fNUM
,COUNT(*) fSUM
,P.FDWID AS fOwerOrgID
FROM
ECON_Proj_MultiBusiness S
LEFT JOIN BC_MT_Project P
ON P.FID = S.fProjectID
WHERE
S.fState = '在施'
AND S.FSFQDZRS = '是'
GROUP BY
P.FDWID;