Which JOIN returns all rows from the left table and matching rows from the right, with NULLs where there is no match?
- A INNER JOIN
- B LEFT JOIN
- C RIGHT JOIN
- D CROSS JOIN
Answer
LEFT JOIN
A LEFT JOIN preserves every row from the left table. Putting a condition on the right table in WHERE rather than ON silently converts it to an INNER JOIN.





