The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns in both tables.
PS! INNER JOIN is the same as JOIN.
In this tutorial we will use the well-known Northwind sample database.
Below is a selection from the "Customers" table:
||Alfreds Futterkiste||Maria Anders||Obere Str. 57||Berlin||12209||Germany|
|2||Ana Trujillo Emparedados y helados||Ana Trujillo||Avda. de la Constitución 2222||México D.F.||05021||Mexico|
|3||Antonio Moreno Taquería||Antonio Moreno||Mataderos 2312||México D.F.||05023||Mexico|
And a selection from the "Orders" table:
The following SQL statement will return all customers with orders:
Note: The INNER JOIN keyword selects all rows from both tables as long as there is a match between the columns. If there are rows in the "Customers" table that do not have matches in "Orders", these customers will NOT be listed.
Your message has been sent to W3Schools.