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

Orders Table Customer Table Customer Table
Order Amount Customer Name Customer ID
19164.30 BG Mountain Inc. 53
1683.60 BG Mountain Inc. 53
15716.40 Hansen MTB Inc. 57
1956.20 La Bomba de Bicicleta 58
24580.50 Mountain Toad 60
7911.80 SFB Inc. 62
19766.20 Sierra Bicycle Group 63
12763.95 Sierra Bicycle Group 63
8233.50 Sierra Mountain 64
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
680 Crystal Reports 2008 SP3 User's Guide
Understanding Databases 25
Linking tables