PPT Slide
select s.studentid, s.studentname, sc.classid
from student s, stud_class sc
where s.studentid = sc.studentid(+);
ID STUDENTNAME CLASSID
---- -------------------- ----------
6 Vladimir Babic 1
6 Vladimir Babic 2
6 Vladimir Babic 3
1 Svjetlana Djuric 4
5 Jankovic Milan
3 Tomic Marija 3
Previous slide
Next slide
Back to first slide
View graphic version