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 only
D. To retrieve rows from the second table only

Solution

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