Adding a local join

A local join is temporary and only exists in the Query Builder for one session. The object using the resulting query hold the properties of this local join while it is in use.

To add a local join:

Access the Query Builder. See Accessing the Query Builder
Select a table. See Selecting Tables and Fields
Select a field. See Selecting Tables and Fields
Click the Create Local Join link.
In the Local Join window, the table and field selected from the Query Builder display under the Parent Table and Join Field section.
Select the database table and field to which you are creating the local join under Child Table and Join Field.
Select the type of join under Join Type. See Join types
The default value is Inner join.
Click OK.