User`s guide

Note:
Left Outer and Right Outer joins are handled differently in the SQL language from other join types. If
the database is accessed through ODBC, Crystal Reports uses ODBC syntax in the SQL statement.
If you are connecting to a SQL database directly (not through ODBC), Crystal Reports uses a syntax
native to the database. For more information about what an Outer join looks like in an SQL statement,
refer to Microsoft ODBC documentation or to the documentation for your SQL database.
23.5.10.4 Full Outer join
A Full Outer join is a bidirectional outer join where you can see all records in your linked tables. The
result set from a Full 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, and 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, and a row for every customer for whom an
order cannot be found.
Orders TableOrders TableCustomer Table
Order AmountOrder IDCustomer ID
25141.50652
19164.301153
1683.602153
15716.40457
1956.202058
24580.501660
7911.801962
19766.202863
2012-03-14535
Understanding Databases