|
主表,区域表:上面有两个字段,省份和是否市级授权
现在要根据省份group by ,当不是市级授权的时候就group by 省份,当是市级授权的时候就group by 市
SELECT
a.fArea AS fArea
,a.fAreaCompany AS fAreaCompany
,a.fAuthorizeManagerUnit AS fAMU
,a.fProjProvince AS fProjProvince
,SUM(COALESCE(c.fRealContractAmount, 0)) AS fRCA
FROM
ECON_Proj_RegionRegister a
LEFT JOIN BC_MT_Project b
ON a.fProjProvince = b.fSZSF
LEFT JOIN ECON_Proj_MULTIBUSINESS c
ON c.fProjectID = b.fid
LEFT JOIN ECON_Proj_Business d
ON d.fProjectID = c.fProjectID
LEFT JOIN ECON_Proj_FINANCE e
ON e.fProjectID = c.fProjectID
AND e.FYEAR = c.FYEAR
AND e.FPERIOD = c.FPERIOD
WHERE
b.fSGZT2 = '在施'
AND a.fProjProvince IN (
SELECT
q.fProjProvince
FROM
ECON_Proj_RegionRegister q
WHERE
q.fIsLevelEmpower = '0'
AND q.fUseStatusName = '启用'
)
GROUP BY
a.fProjProvince
,a.fArea
,a.fAreaCompany
,a.fAuthorizeManagerUnit
,a.fProjProvince;
|
|