SELECT
pt.project_id,
pt.project_name,
ROUND(sum(allC), 2) v1,
ROUND(sum(allF), 2) allF,
(SELECT v1) t
FROM
project_tab pt
LEFT JOIN ts_company_arch tca ON pt.project_id = tca.project_id
LEFT JOIN ts_job_arch tja ON tca.arch_id = tja.arch_id
WHERE
pt.state = 1
AND pt.area_id = 2
GROUP BY
pt.project_id,
pt.project_name
其中allC 我取了别名 就会报错
Reference 'v1' not supported (reference to group function)
解决方案就是不要取别名或者取的别名也为allC,如下:
SELECT
pt.project_id,
pt.project_name,
ROUND(sum(allC), 2) ,
ROUND(sum(allF), 2),
(SELECT allC) t
FROM
project_tab pt
LEFT JOIN ts_company_arch tca ON pt.project_id = tca.project_id
LEFT JOIN ts_job_arch tja ON tca.arch_id = tja.arch_id
WHERE
pt.state = 1
AND pt.area_id = 2
GROUP BY
pt.project_id,
pt.project_name