Explanation of LEFT OUTER JOIN:
The query result set will contain data from the LEFT table even when there is no corresponding data in the RIGHT table, but not vice versa.
The LEFT table is specified on the left side of the JOIN statement, and the RIGHT table is specified on the right side of the JOIN statement.
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 |
10251 |
08-Aug-05 |
VICTE |
|
|
10252 |
09-Aug-05 |
SUPRD |
Suprêmes délices |
Belgium |
10253 |
10-Aug-05 |
HANAR |
Hanari Carnes |
Brazil |