select
a.a1, a.a2, a.a3,c.c1
from
a left join c on a.unit_no = c.unit_no
left join sa on r.salary = sa.code
join (select j.joint_no from j join m on j.meeting_no = m.meeting_no
where m.meeting_no = '266') s on r.joint_no = s.joint_no
where
r.degree = '03'
and r.unit_No = '2815'
oracle多表关联的join写法
最新推荐文章于 2023-08-08 15:51:59 发布