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

Solution

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