User`s guide

Orders TableCustomer TableCustomer Table
Order AmountCustomer NameCustomer ID
25141.50Allez Distribution52
19164.30BG Mountain Inc.53
1683.60BG Mountain Inc.53
15716.40Hansen MTB Inc.57
1956.20La Bomba de Bicicleta58
24580.50Mountain Toad60
7911.80SFB Inc.62
19766.20Sierra Bicycle Group63
12763.95Sierra Bicycle Group63
8233.50Sierra Mountain64
23.5.10.2 Left Outer join
The result set from a Left Outer join includes all the records in which the linked field value in both tables
is an exact match. It also includes a row for every record in the primary (left) table for which the linked
field value has no match in the lookup table. For instance, you can use a Left Outer join to view all
customers and the orders they have placed, but you also get a row for every customer who has not
placed any orders. These customers appear at the end of the list with blanks in the fields that would
otherwise hold order information:
2012-03-14532
Understanding Databases