Click the SQL/ODBC or Dictionary button.

●If you click SQL/ODBC:

¾Highlight an SQL or ODBC data source in the Log On Server dialog box.

¾Choose one or more database tables in the Choose SQL Table dialog box. Click Add to add each table to your SQL query. Click Done when finished.

●If you click Dictionary:

¾Highlight Dictionary (.DC5) in the File Open dialog box, and click OK.

¾All ODBC database tables accessible from the dictionary will be added to your SQL query.

NOTE: Dictionary files must be based on an ODBC data source.

See Dictionaries, Page 491, for further information.

How to link tables and specify a join type

Generates WHERE clause

The WHERE clause indicates how two database tables are joined.

NOTE: Some links can be generated in the FROM clause.

474	Seagate Crystal Reports User’s Guide

Click the Links Tab and click the Smart Linking button. The Create Query Expert will make any possible links it can detect between tables. These links are represented by an arrow between fields in two tables, called a link line.

Link line.

Click one of the link lines between tables. The link line becomes highlighted, along with the fields in each table that it is linking.

!Click the Options button to open the Link Options dialog box. This dialog box describes the link between the tables in more detail. Search for Link Options dialog box in Crystal Query Designer online Help.

Queries

475

4 Select an SQL join type.

Related Topics

SQL join types (ODBC data sources), Page 537

WHERE, Page 552

How to add fields to a query

Generates SELECT clause

The SELECT clause selects specific data items to retrieve from the database tables indicated by the FROM clause.

Click the Fields Tab in the Create Query Expert.

476	Seagate Crystal Reports User’s Guide

2 Highlight the fields you want to		3 Click the
appear in your query from this list.		Add button.

The field(s) will be added to this list.

Click Remove to remove any fields from the Query Fields list box.

Related Topics

SELECT, Page 551

How to identify unique values in a query

Generates DISTINCT clause

DISTINCT forces the query to retrieve only unique (distinct) sets of data.

Click the Fields Tab of the Create Query Expert.

Queries

477