plsql 多表查询

修正楼上语句
select d.id,d.code,d.name,d.date,c.s1+c.s2+c.s3-d.sl zhsl,je,(c.s1+c.s2+c.s3-d.sl)*c.je zje
from
(select max(a.id) id,a.code,a.name,sum(a.sl) sl,max(b.date) date from a,b where a.id = b.id group by a.code,a.name ) d,c
where d.code = c.code ;

select d.id,d.code,d.name,d.date,c.s1+c.s2+c.s3-d.sl as zhsl,je,(c.s1+c.s2+c.s3-d.sl)*c.je as zje from (
select a.id,a.code,a.name,sum(sl) as sl,max(date) as date from a,b where a.id = b.id
group by a.id,a.code,a.name ) d,c
where d.code = c.code