SQL INNER JOIN

The INNER JOIN  selects records that have matching values in both tables.

INNER JOIN Syntax:

SELECT column_name(s)
FROM table1
INNER JOIN table2 ON table1.column_name = table2.column_name;