Select this option to build a Join clause.  A Join clause lets you retrieve and manipulate data from multiple tables in a single select statement.

Pressing OK in the Join dialog box adds the Join clause to the Select Statement.  The SQL Statement window displays the Join clause as part of the current SQL statement.

Join Dialog Box

Join Tables:

The tables to be used in the Join clause are displayed.

Over Columns:

A list of matching primary key columns is displayed if the Display Matching Columns Only check box is selected.

A list of all columns in the tables is displayed if the Display Matching Columns Only check box is not selected.

Highlight the columns to use in the Join clause.

Display Matching Columns Only:

Check this box to display matching columns only (the default).  Uncheck this box to display all columns in the tables.

Operator:

Select a comparison operator.

Clause Options:

The Join clause is displayed here.

Use the Add button to add the expression you have built to the Join clause.  The Add button may be used to build several conditional expressions into the Join clause.

Use the Remove button to remove portions of the Join clause, or the Clear All button to erase the entire Join clause.