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:
|
|
Tables are joined on the CUSTID column. Shaded CustID values do not have a matching CustID in the other table.
SQL statement:
SELECT |
OrderID, OrderDate, Orders.CustID, CustName, Country |
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 |