阅读背景：

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 SELECT pt.project_id, pt.project_name, ROUND(sum(a

你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到：
你可能喜欢:
相关阅读:
随便看看: