Reference 'v1' not supported (reference to group function) 解决方案

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