PPT Slide
Using those two tables, let's say you would like to select the student's name, and classID they've completed. Here is an example of a join statement to accomplish this:
Predpostavimo da je neko od nas zahtevao da napravimo izvestaj koji sadrzi ime studenta i kurseve koje je ovaj zavrsio:
select s.studentid, s.studentname, sc.classid
from student s, stud_class sc
where s.studentid = sc.studentid;