Intermediate
SQL
Q74 / 100
What does "FULL OUTER JOIN" return?
Correct! Well done.
Incorrect.
The correct answer is B) All rows from both tables, with NULLs filled in for non-matching columns on either side
B
Correct Answer
All rows from both tables, with NULLs filled in for non-matching columns on either side
Explanation
FULL OUTER JOIN combines LEFT and RIGHT JOIN behavior, returning all rows from both tables and filling unmatched columns with NULL.
Progress
74/100