What is INNER JOIN in SQL?

INNER JOIN combines rows from two or more tables, returning only those for which there are matches in the specified columns of both tables.

SELECT column1, column2
FROM table1
INNER JOIN table2 ON table1.matching_column = table2.matching_column; 

The result of INNER JOIN contains only records that are present in both tables based on the join condition. If a record from one table does not have a corresponding record in the other table according to the condition, it is not included in the result.