A join in which rows that do not have matching values in common columns are still included in the result table is called a(n):
A) natural join.
B) equi-join.
C) outer join.
D) union join.

Name: A join in which rows that do not have matching values in common columns are still included in the result table is called a(n): A) natural join. B) equi-join. C) outer join. D) union join.
Brand: Quizplus
Rating: 4.9 (37 reviews)

Question

Quizplus · Accepted Answer

An outer join includes rows that do not have matching values in common columns by filling in NULLs for the missing matches.

A Join in Which Rows That Do Not Have Matching