Intermediate
SQL
Q59 / 100
What does "RIGHT JOIN" return that differs from "LEFT JOIN"?
Correct! Well done.
Incorrect.
The correct answer is B) RIGHT JOIN returns all rows from the right table plus matching rows from the left, filling unmatched left-side columns with NULL — the mirror image of LEFT JOIN
B
Correct Answer
RIGHT JOIN returns all rows from the right table plus matching rows from the left, filling unmatched left-side columns with NULL — the mirror image of LEFT JOIN
Explanation
RIGHT JOIN preserves all rows from the right-hand table (with NULLs for non-matching left-side columns), the opposite orientation of a LEFT JOIN.
Progress
59/100