FIT100
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