On the
Join Tables page,
you can add multiple tables to join with the source table that you
have selected. The source table can also be joined to itself. When
a table is added to the
Join tables list,
the application scans the column names in the join table and attempts
to find a matching column name and type. If a match is found, then
the
Source table column and
Join
table column menus are set to the column name. If no
match is found or you prefer a different join condition, set the menus
appropriately. The join is performed with an INNER JOIN syntax. You
can specify one join condition for each table that is joined with
the source table.
Tip
In the
Available
items and
Selected items lists,
make sure that you select the columns that you want to include in
the prepared data and move them to the
Selected items list.