| Join Example |
|
|
|
|
|
|
|
|
|
|
| Find
the students of a given professor |
|||||||||
| SELECT Student.FirstN, Student.LastN, |
|||||||||
| Faculty.LastN |
|||||||||
| FROM (Student INNER JOIN Faculty |
|||||||||
| ON Student.Advisor =
Faculty.Fac_ID) |
|||||||||
| • | Notice that selection comes from the |
||||||||
| combined (by Inner Join) table |
|||||||||