Question

oracle多表连接问题，急！！两个表，查出下面的两个结果

查出这样的 两个 结果，并显示





Answer 1

1、select stu.sid,name,nvl(y.mc,0) classname from stu,(select sid s,max(class) mc
from stu_class group by sid) y where stu.sid=s;

2、select stu.sid,name,nvl(y.mc,0) classname from stu,(select sid s,max(class) mc
from stu_class group by sid) y where stu.sid=s(+) order by stu.sid;