Select the statement that is correct about the outer join operator:
A) The outer join operator generates the join result (the matching rows).
B) The outer join operator generates the join result (the nonmatching rows).
C) The outer join operator generates the join result (the matching rows) plus the nonmatching rows.
D) The outer join operator generates the join result (the nonmatching rows) but excludes the matching rows.

Question

Quizplus · Accepted Answer

The outer join operator generates the join result (the matching rows) plus the nonmatching rows. It includes all rows from both tables and shows NULL values for nonmatching rows.

Select the Statement That Is Correct About the Outer Join