1.
Which SQL JOIN returns all rows from the left table and matching rows from the right table (NULL for non-matches)?
A
INNER JOIN
B
RIGHT JOIN
C
LEFT JOIN
D
FULL OUTER JOIN
Answer and explanation
Correct Answer: C — LEFT JOIN
LEFT JOIN returns all rows from the left table. For rows in the left table with no match in the right table, NULL is returned for right-table columns.