STUDENT$($StudentID$,$ StudentName, AdvisorID$)$

ADVISOR$($AdvisorID$,$ AdvisorName, Office, Phone$)$

Which of the following SQL statements would be used to implant a join between the two tables?

WHERE STUDENT MATCH ADVISOR

WHERE STUDENT.AdvisorID MATCH ADVISOR.AdvisorID

WHERE STUDENT JOIN ADVISOR

WHERE STUDENT JOIN ADVISOR ON STUDENT.AdvisorID $=$ ADVISOR.AdvisorID