ObjectiveMcq
Print Protected
This page is protected for print. Use the website to view the 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
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.