User`s guide

Orders TableCustomer TableCustomer Table
Order AmountCustomer NameCustomer ID
25141.50Allez Distribution52
19164.30BG Mountain Inc.53
1683.60BG Mountain Inc.53
15716.40Hansen MTB Inc.57
1956.20La Bomba de Bicicleta58
24580.50Mountain Toad60
7911.80SFB Inc.62
19766.20Sierra Bicycle Group63
12763.95Sierra Bicycle Group63
8233.50Sierra Mountain64
Bicicletas Aztecas54
Deely MTB Inc.55
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 an 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.
2012-03-14533
Understanding Databases