Create a(n)_____ join to relate an Employee table to itself using two fields in the same table to identify the relationship between employees and supervisors.
A) inner
B) outer
C) self
D) referential

Question

Quizplus · Accepted Answer

A self join is used to relate a table to itself. In this case, the Employee table is being joined to itself using two fields to identify the relationship between employees and their supervisors. An inner or outer join would not be appropriate as we are not joining with another table. Referential join is not a valid term in SQL.

Create A(n)_____ Join to Relate an Employee Table to Itself