PPT Slide
select s.studentid, s.studentname, sc.classid
from student s, stud_class sc
where s.studentid = sc.studentid;
select s.studentid, s.studentname, sc.classid
from student s, stud_class sc
where s.studentid = sc.studentid(+);
Ovo je “Left Dominant Join”.
Takodje postoji “Right Dominant Join”.