Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 8. Pokaż dane (ident., nazwisko, tytuł) o nauczycielach, którzy uczyli wszystkich studentów.
- SELECT TNo, TName, Title
- FROM Teachers
- WHERE NOT EXISTS
- (SELECT *
- FROM Students
- WHERE NOT EXISTS
- (SELECT *
- FROM TS
- WHERE Teachers.TNo = TS.Tno AND
- Students.SNo = TS.SNo));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement