What is the purpose of the SQL LEFT JOIN?

A. To retrieve all rows from both tables, even if there is no match

B. To retrieve only the common rows between two tables based on a related column

C. To retrieve rows from the first table and matching rows from the second table

D. To retrieve rows from the second table and matching rows from the first table

Correct Answer is :

C. To retrieve rows from the first table and matching rows from the second table