You can use these properties to specify tables involved in the join.
| Use this | To do this |
|---|---|
| Source table | Specify the table that contains the field (primary key) from which the join originates. |
| Destination table | Specify the table that contains the field (foreign key) to which the join is made. |
| Join conditions | Specify the fields that make up the primary and foreign keys in the join. You can add, edit, or delete a join. |
| Never use outer join | Specify that it is never necessary to use this join as an outer join, as all rows in the source table 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" normally 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 you know that all employees are assigned to buildings, you can select this option. Doing so improves the performance of the query. |