Utilizor

SQL Inner Join

Select records used in both tables.

SQL INNER JOIN Keyword

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

Syntax

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

Note: The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns. If there are records in the "Orders" table that do not have matches in "Customers", these orders will not be shown!