Chapter 9 Supplemental Slides

1
Chapter 9 Supplemental Slides
Type II Nested Query Demonstration
2
Type II Nested Query Animation
SELECT FacSSN, FacLastName, FacDept FROM
Faculty WHERE NOT EXISTS ( SELECT FROM
Student WHERE Student.StdSSN
Faculty.FacSSN )
3
Type II Nested Query Animation
4
Type II Nested Query Animation
Result
FacSSN

FacLastName

FacRank





5
Type II Nested Query Animation
Result
FacSSN

FacLastName

FacRank

098
-
76
-
5432

VINCE

ASST



6
Type II Nested Query Animation
Result