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

Self Join

A type of SQL join where a table is joined to itself to extract rows that compare with other rows in the same table based on a certain join condition.

Referential

Pertaining to systems, actions, or processes in computing that establish or use references or relationships between different data elements or structures.