What is the purpose of the SQL INNER 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 only

D. To retrieve rows from the second table only

Correct Answer is :

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