SQL INNER JOIN

SQL INNER JOIN Description

The INNER keyword JOIN selects 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

SQL INNER JOIN

Demonstration database

Below is a sample from the table "Orders" ("Orders"):

ProductID	OrderID	CustomerID	EmployeeID	OrderDate	ShipperID
1	10248	90	5	1996-07-04	3
2	10249	81	6	1996-07-05	1
3	10250	34	4	1996-07-08	2

And the selection from the table "Customers" ("Customers"):

CustomerID	CustomerName	ContactName	Address	City	PostalCode	Country
1	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.	5021	Mexico
3	Antonio Moreno Taquería	Antonio Moreno	Mataderos 2312	México D.F.	5023	Mexico

SQL INNER JOIN Example

The following SQL statement selects all orders with customer information:

Run SQLSELECT Orders.OrderID, Customers.CustomerName
FROM Orders
INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID

The INNER keyword JOIN selects all rows from both tables if there is a match between the columns. If there are records in table "Orders" ("Orders") that do not match in "Customers" ("Customers"), those orders will not be displayed!

SQL INNER JOIN to join three tables

The following SQL statement selects all orders with customer and shipper information:

Run SQLSELECT Orders.OrderID, Customers.CustomerName, Shippers.ShipperName 
FROM ((Orders INNER JOIN Customers 
       ON Orders.CustomerID = Customers.CustomerID) 
       
      INNER JOIN Shippers 
      ON Orders.ShipperID = Shippers.ShipperID)