Question

Which type of SQL JOIN returns all rows from the left table, and the matched rows from the right table (with NULLs where there is no match)?

A INNER JOIN
B RIGHT JOIN
C LEFT JOIN
D FULL OUTER JOIN
E CROSS JOIN
Practice Next

Hey! Ask a query