Adding and Editing Joins

Adding and Editing Joins

Selection of the Add Join button in the Define Query dialog box opens the Add Join dialog box, which is used to create a Join condition. This button is only available when more than one table is included in the query definition. As joins are added to the query definition, they are shown in the Joins in Query list box.

Selection of the Edit Join button in the Define Query dialog box opens the Edit Join dialog box, which is used to modify a Join condition selected from the Joins in Query list box.. This button is only available when a join has been selected from the Joins in Query list box, which is populated either by the user or when tables containing duplicate column names have been included in the query definition.

The Left column and Right column combo-boxes in the Add Join and Edit Join dialog boxes contain lists of all the columns in the tables included the query (not just the columns in the Columns in Query list box). Choose a pair of columns using the list boxes, and specify the join type using one of the three available radio buttons.

Note: Databases do not allow outer joins when there are more than two tables selected for the query. For this reason, the outer join radio buttons will not be available when more than two tables are included in the query. In addition, if an outer join has been specified, and a third table is added to the query, a Warning Message will allow you to either convert the outer join to an inner join, or forgo adding the table.