You must specify the columns that will be used to join
the tables.
About this task
The Join Columns window opens automatically
as the second phase to specifying join conditions for multiple tables
when you are building a query using the Prompted Query editor.
Rows in each of the tables that have equal values in these columns
will be joined.
To join columns:
Procedure
- Open the Join Columns window using
the Prompted Query editor.
- Select one column from the Available columns
to join list.
The columns from all the
tables that have been included in the query are listed.
You
must select a column with the same data type (NUMERIC, DATE, TIME)
as the column selected in the Columns of (table name) list.
- Select one column from the Columns of (table
name) list.
Only the columns from the right
table (the table that you are joining) are listed.
You must
select a column with the same data type (NUMERIC, DATE, TIME, CHARACTER)
as the column selected in the Available columns to join list.
- Click Add.
Rows
that have equal values in the columns that are listed in the Available
columns to join list and the columns that are listed in
the Columns of (table name) list will be joined.
The Join
Columns window closes.
What to do next
The next step is to specify what columns will be in the
query results.