Creating joins in the SQL designer

Topic group

In the SQL designer, fields can be linked by dragging one or more fields from one table to the fields on another table. Graphically, a join is indicated by a single line that connects the two table windows at their table name.

Each linked field pair in the join is added as a separate row to the Joins page grid. When a join line is selected in the table pane, the join list box (above the Join page grid) will contain the two joined tables.

To create a join

1. In the first Field column, select the field you want to match from the first table.

2. In the Op column, select the appropriate type of match. You may choose from =, <, >, <=, >=, and <>.

3. In the second Field column, select the field you want to match from the second table.