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

Orders Table Orders Table Customer Table
Order Amount Order ID Customer ID
19164.30 11 53
1683.60 21 53
15716.40 4 57
1956.20 20 58
24580.50 16 60
7911.80 19 62
19766.20 28 63
12763.95 32 63
8233.50 14 64
10320.87 25
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
Crystal Reports 2008 SP3 User's Guide 683
25 Understanding Databases
Linking tables