Configure Joins

Use this screen to create or delete joins. Since multiple tables are required for joins, you must have selected fields from multiple tables on the Select Fields screen in order to configure joins. If you have only selected fields from one table, this step is bypassed.

Note Note

This is an optional step.
The type of join created with this step is an inner join (intersect).

End of the note.

Structure

The main controls of this screen are listed in the following table:

Control	Description
Left Field	Lists all fields from all the tables selected on the Select Fields screen. Select the join field for the left table.
Operator	Lists operators that specify how the left and right fields should be compared. Available operators are: `=` (Equal to) `>` (Greater than) `<` (Less than) `>=` (Greater than or equal to) `<=` (Less than or equal to) `<>` (Not equal to)
Right Field	Lists all fields from all the tables selected on the Select Fields screen. Select the join field for the right table. The Left Field and Right Field selections must be from different tables.
Add	Adds the join configured by the Left Field, Operator, and Right Field lists to the Joins list. You may add as many joins as you want.
Joins list	Lists the currently configured joins.
Delete	Deletes a selected join from the Joins list.