To add a join by selecting
a column name and dragging your pointer to another column:
-
Place your pointer on
one of the columns in a table to use, and then click and drag your
pointer to a column in the other table to use in the join.
-
If you want a join type
other than an inner join, then select the join, right-click, and select
the join type.
Tip
The first table that is added
to the workspace is always set as the left table.
You
can switch the right table and left table by using the Joins tab.