Loading content
Which SQL JOIN returns all rows from the left table and matching rows from the right table (NULL for non-matches)?
Correct Answer: C — LEFT JOIN
Explanation:
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.