A join based upon a column from each table containing equivalent data is known as a(n)____.
A) inequality join
B) outer join
C) equality join
D) all of the above

Question

​A join based upon a column from each table containing equivalent data is known as a(n)____.
A) ​inequality join
B) ​outer join
C) ​equality join
D) ​all of the above

Quizplus · Accepted Answer

A join based on a column from each table containing equivalent data is known as an equality join. An inequality join would involve using a comparison operator such as less than or greater than in the join criteria while an outer join would include all rows from one or both of the tables, even if there is no match in the other table. Therefore, the best choice is C - equality join.

​A Join Based Upon a Column from Each Table Containing

A Join Based Upon a Column from Each Table Containing