你写的是oracle的sql吧?select a.seriary_id,a.project_name,a.sell_id,b.cost,sum(c.arr_sum) as arr_sum,(b.cost-sum(c.arr_sum)) as acceptcost from project as a
left outer join projectinfo as b on a.id=b.project_id
left outer join arrearage as c on a.id=c.project_id
group by a.id;
left outer join projectinfo as b on a.id=b.project_id
left outer join arrearage as c on a.id=c.project_id
group by a.id;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货