User Guide

30
Chapter 3
Figure 3-6
Creating an inner join
Outer joins. A left outer join includes all records from the table on the left and only
those r
ecords from the table on the right in which the related fields are equal. In a
right outer join, this relationship is switched, so that the join imports all records from
the table on the right and only those records from the table on the left in which the
relat
ed fields are equal.