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 will hold the properties of this local join while it is in use.

To add

1. Open Query Builder.
2. Select a table.
3. Select a field.
4. Click the Create Local Join link.

In the Local Join dialog box, the table and field selected from the Query Builder appear under the Parent Table and Join Field section.

5. Under Child Table and Join Field, select the database table and field to which you are creating the local join.
6. Under Join Type, select the type of join.

The default is an Inner join.

7. Click OK.

Related Topics

Joining Tables

Join Example