Managing Joins in a Query :: SAS(R) Visual Data Builder 6.2: User's Guide

Once a join is added to a query, you can change the join by selecting it in the workspace, right-clicking, and changing the join type or removing the join condition.

You can also change a join by clicking the Joins tab, and then selecting the row in the table. You can make the following changes:

add and remove tables from the join list
reorder the sequence of joins by moving them up or down
switch the left table and right table assignments for a join
add, remove, and change the columns that are used in the join condition

The Joins tab shows the join condition for the entire query. Make sure that you select a row in the upper table to set the columns in the Join conditions area.

The workspace shows a link between the tables that are used in a join. If you specify a left join or right join, the Venn diagram icon reflects which table provides the bulk of the data. If you rearrange the tables in the workspace (switching the left table and right table), the Venn diagram icon continues to reflect which table provides the bulk of the data. In order to change the data relationship, use either of the following methods:

Switch the left table and right table by selecting a row from the table, and clicking .
Change the join type from left to right or from right to left.