Given the Tables STUDENT(StudentID,StudentName,AdvisorID)

Multiple Choice

Given the tables
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?

A) WHERE STUDENT MATCH ADVISOR
B) WHERE STUDENT.AdvisorID MATCH ADVISOR.AdvisorID
C) WHERE STUDENT = ADVISOR
D) WHERE STUDENT JOIN ADVISOR
E) WHERE STUDENT JOIN ADVISOR ON STUDENT.AdvisorID = ADVISOR.AdvisorID