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 data 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, then the
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), then the
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.