Defining Join Relationships
You can create join relationships between tables automatically, or by manually joining particular table columns.
To automatically join tables, follow the steps below:
1. Click the 'Auto Join' button in the toolbar. This opens the 'Generate Joins' dialog box.

2. Select 'By Key Relation' to join columns by using primary key/foreign key definitions, or 'By Column Name' to join columns by using common column names.
3. Select the desired columns in the 'Available Columns' panel.
4. Click the right-arrow button to add the selected columns to the 'Key Columns' panel.
5. Click 'Finish' to automatically add the requested joins to the physical view.
To manually define a join between two tables, click a column name in the first table, and drag and drop the column name onto the corresponding column in the second table.

See Also
Defining the Join Type, for information on modifying a join.
| << Adding an Embedded SQL View | © 1996-2013 InetSoft Technology Corporation (v11.5) | Defining the Join Type >> |