A join in which one of the two identical join columns in the result is eliminated is called a(n) ____.
A) semijoin
B) equijoin
C) compound join
D) natural join
E) complex join

Question

Quizplus · Accepted Answer

A natural join automatically eliminates duplicate columns by joining tables based on columns with the same names and data types, resulting in only one of the two identical join columns being present in the result set.

A Join in Which One of the Two Identical Join