HP Intelligent Management Center Standard Software Platform - Manual (Page 684)

like in an SQL statement, refer to Microsoft ODBC documentation or to the
documentation for your SQL database.
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 Table Orders Table Customer Table
Order Amount Order ID Customer ID
25141.50 6 52
19164.30 11 53
1683.60 21 53
15716.40 4 57
1956.20 20 58
24580.50 16 60
684 Crystal Reports 2008 SP3 User's Guide
Understanding Databases 25
Linking tables