Explanation of FULL OUTER JOIN:
The query result set will contain data from the LEFT table even when there is no corresponding data in the RIGHT table. It will also contain data from the RIGHT table even when there is no corresponding data in the LEFT table.
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 |
|
|
|
GREAL |
Great Lakes Food Market |
USA |
|
|
|
TORTU |
Tortuga Restaurante |
Mexico |