We have two tables ‒ one called students and one called advisors. The students table contains a field called advisor_id that references an id within the advisors table. Not all students have an advisor, and not all advisors are assigned to students. If we wanted to pull information on students and their advisors, EXCLUDING students who are not assigned to an advisor, we would use: