What is a LEFT JOIN in SQL?

Question

Accepted Answer

(B) Returns all rows from left table and matching rows from right. Explanation: LEFT JOIN returns all rows from the left table and matched rows from the right; unmatched right rows are NULL.