A type of join where a table is joined to itself is called a(n):
A) ternary join.
B) self-join.
C) unnatural join.
D) pinned join.

Question

Quizplus · Accepted Answer

A self-join is where a table is joined to itself. This is useful when analyzing hierarchical data, such as an organizational chart, where each record in the table contains a reference to the parent record in the same table. By performing a self-join, it is possible to retrieve all the child records for a given parent record.

A Type of Join Where a Table Is Joined to Itself