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