Creating a Query Using Multiple Tables

To generate a query that joins and retrieves information from two tables, use the PRODUCTS and SALES tables.

1. Drag the PRODUCTS table from the Navigator to the Design window.
2. Drag the SALES table from the Navigator to the Design window.
3. Create a join between the tables by linking the PR_ID fields of both tables. To automatically create joins between identically named attributes within tables or views:
   1. Select File > Preferences from the main Sybase IQ InfoPrimer Development window.
   2. Select Workbench > Query Designer, then select Create joins automatically.
4. To view join attribute details, click the Join tab in the Query Designer window.