Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT sw.id_studenta, nazwisko, nazwa_wykladu
- FROM studenci_wyklady sw
- LEFT JOIN oceny_studentow os on sw.id_wykladu=os.id_wykladu and sw.id_studenta=os.id_studenta LEFT JOIN wyklady ON sw.id_wykladu = wyklady.id_wykladu LEFT JOIN studenci ON sw.id_studenta=studenci.id_studenta
- WHERE os.ocena is null
- ORDER BY id_studenta ASC, nazwisko ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement