How to add a join

In English Query, when a new table or view is added to the model, associations between the new table or view and an existing table or view must be made. The associations are made by adding a join.

To add a join

1. On the SQL tab, expand Tables, and select the table to which the join is added.
   
   
2. Expand the table, right-click Joins, and click Add Join.
   
   
3. In the New Join dialog box, select the name of the Destination Table for the join.
   
   
4. Click Add.

   Note  If the Add button is not available, select a Destination Table.

5. In the Join Condition dialog box, select the pair of fields to be joined, and click OK.
   
   
6. Click Allow outer join if it is necessary to use this join as an outer join.

See Also

Join/New Join Dialog Box

Model Editor

SQL Tab (Model Editor)