ORACLE 如何实现如下SQL的功能
select *
from setudent s
left join (select a.name, a.classid
from clase a
where a.classid = s.classid) b
on b.classid = s.classid
select *
from setudent s
left join (select a.name, a.classid
from clase a
where a.classid = s.classid) b
on b.classid = s.classid
select *
from setudent s
left join clase a
on a.classid = s.classid