User`s guide

23.5.10.3 Right Outer join
The result set from a Right 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 lookup (right) table for which the
linked field value has no match in the primary table. If you link the Customer table to the Orders table,
you get one row in the table for each order a customer has placed. You also get a row for every order
found that cannot be linked to a customer. Theoretically, this should not happen, but if an inexperienced
sales person forgot to assign a customer ID to an order, you can quickly locate that order with a Right
Outer join. The resulting table leaves a blank in any of the Customer fields for the order without a
customer.
Orders TableOrders TableCustomer Table
Order AmountOrder IDCustomer ID
25141.50652
19164.301153
1683.602153
15716.40457
1956.202058
24580.501660
7911.801962
19766.202863
12763.953263
8233.501464
10320.8725
2012-03-14534
Understanding Databases