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

Question

Quizplus · Accepted Answer

The correct syntax for joining two tables is to use the JOIN keyword followed by the table name and the ON keyword to specify the column(s) to join on. In this case, we want to join the STUDENT and ADVISOR tables on the AdvisorID column, so the correct statement would be "WHERE STUDENT JOIN ADVISOR ON STUDENT.AdvisorID = ADVISOR.AdvisorID".

Given the Tables STUDENT(StudentID,StudentName,AdvisorID)