(INNER) JOIN Select records that have matching values in both tables.

SQL INNER JOIN Syntax:

SELECT column_name(s)

FROM table1

INNER JOIN table2

ON table1.column_name = table2.column_name;

Example:

Lets use the “Customer” and “Orders” tables to perform an INNER JOIN based on CustomerID.

Results:

SQL Tutorial