mysql中如何写一句与以下这个语句功能一样的sql

[qukmei]

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,projectinfo as b,arrearage as c where a.id=b.project_id(+) and a.id=c.project_id(+) group by a.id


谢谢！主要是字段的左连接

[mathematician]

你写的是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;