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
![Join icon](images/venndiagramand.png)
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
![Join icon](images/venndiagramand.png)
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
![the Switch the left and right tables button](images/swap.png)
.
-
Change the join type from left to right or from right to left.