#### SQL join types (ODBC data sources)

Seagate Crystal Reports enables you to specify the type of join you want to use when linking SQL tables. An SQL join indicates how linked fields in two SQL tables are compared when records are read. The SQL Join Type options can be specified in the Link Options dialog box.

Note: When you link fields using SQL joins, no indexed fields are required.

The join types are:

- Equal [=] join
- Left Outer [=(+), *=] join
- Right Outer [(+)=, =*] join
- Greater Than [>] join
- Less Than [<] join
- Greater Than Or Equal [>=] join
- Less Than Or Equal [<=] join
- Not Equal [!=, <>] join.

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com