An INNER JOIN is the most common type of join which returns the row in result set where the column value in a row of table1 is equal to the column value in a row of table2.