sample INNER JOIN

Explanation of INNER JOIN:

The query result set will contain only data from both tables for which a corresponding value exists in both tables.

Table contents:

Orders
OrderID	OrderDate	CustID
10248	04-Aug-05	VINET
10249	05-Aug-05	TOMSP
10250	08-Aug-05	HANAR
10251	08-Aug-05	VICTE
10252	09-Aug-05	SUPRD
10253	10-Aug-05	HANAR

Customers
CustID	CustName	Country
GREAL	Great Lakes Food Market	USA
HANAR	Hanari Carnes	Brazil
SUPRD	Suprêmes délices	Belgium
TOMSP	Toms Spezialitäten	Germany
TORTU	Tortuga Restaurante	Mexico
VINET	Vins et alcools Chevalier	France

Tables are joined on the CUSTID column. Shaded CustID values do not have a matching CustID in the other table.

SQL statement:

SELECT
FROM

OrderID, OrderDate, Orders.CustID, CustName, Country
Orders INNER JOIN
Customers ON Orders.CustomerID = Customers.CustomerID

Query result set:

OrderID	OrderDate	CustID	CustName	Country
10248	04-Aug-05	VINET	Vins et alcools Chevalier	France
10249	05-Aug-05	TOMSP	Toms Spezialitäten	Germany
10250	08-Aug-05	HANAR	Hanari Carnes	Brazil
10252	09-Aug-05	SUPRD	Suprêmes délices	Belgium
10253	10-Aug-05	HANAR	Hanari Carnes	Brazil

<< Return to Joining tables