Intermediate
SQL
Q41 / 100
What is the difference between an INNER JOIN and a LEFT JOIN?
Correct! Well done.
Incorrect.
The correct answer is B) INNER JOIN returns only rows with matches in both tables, while LEFT JOIN returns all rows from the left table plus matched rows from the right (with NULLs where there is no match)
B
Correct Answer
INNER JOIN returns only rows with matches in both tables, while LEFT JOIN returns all rows from the left table plus matched rows from the right (with NULLs where there is no match)
Explanation
INNER JOIN excludes rows without a match in both tables, whereas LEFT (OUTER) JOIN preserves all rows from the left table, filling unmatched right-side columns with NULL.
Progress
41/100