select p.project_name,(select sum(c.id) from Charge c where c.project_id=p.id) counts from Project p
把它改成:
select p.project_name,counts.*
from Project p,(select sum(c.id) from Charge c where c.project_id=p.id) cunts
group by ....
试试
把它改成:
select p.project_name,counts.*
from Project p,(select sum(c.id) from Charge c where c.project_id=p.id) cunts
group by ....
试试
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货