Right-click an existing table, and select Add Table and Join to add a new table and the join between the two tables in a single action. The Add Table and Join window opens. Since the table on one side of the join relationship being added is already known, only those tables that can be joined to the current table, and their applicable joins, are presented. Selecting a table automatically selects the appropriate join between the selected table and the table from which the Add Table and Join action was launched. Similarly, selecting a join automatically selects the appropriate table.

If the join should be an outer join, select from the Outer Join Against drop-down list whether the outer join is against the table being added, or if the outer join is against the table from which the Add Table and Join action was launched.

If the join is a link join with interchangeable A and B roles, ensure that the roles are set appropriately. Click the arrow between the roles to swap which type is Role A and Role B:

Select the desired table and join, and click OK.

Once added, the table alias and join can be modified as previously described.