Join/New Join Dialog Box

Use this dialog box to specify tables involved in the join.

Options

Source Table

Specify the table that contains the field (foreign key) from which the join originates.

Destination Table

Specify the table that contains the field (primary key) to which the join is made.

Join Conditions

Specify the fields that make up the primary and foreign keys in the join.

Add/Edit/Delete

Add, modify, or delete a join condition. Click Add or Edit to display the Join Condition dialog box, where you can select fields to be joined.

Allow outer join

Specify an outer join, because all rows in the source table may not have matching rows in the destination table.

For example, the table Employees contains an employee ID, name, and building ID. The table Buildings contains a building ID and a building name. The question, "Show the employees and their buildings" usually generates a query with an outer join from Employees to Buildings so employees who are not assigned to buildings are also displayed in the result set. If all employees are assigned to buildings, clear this option to improve the performance of the query.