Given the tablesSTUDENT(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

E

Business

You might also like to view...

The simplest way to enter a foreign market is through direct investment

Indicate whether the statement is true or false

View
Business

A seasonal index must be between -1 and +1

Indicate whether the statement is true or false

View
Business