Join Column wizard |
Table window, Columns menu |
Select Table and Column |
Next > |
The Join Column wizard guides you to join a column from another table into the current table.
On this first page of the wizard you should select the table and the column that you wish to join into the current table.
Dialog box options:
|
Table: |
Select the table from which you wish to join data. |
|
Column: |
Select the column in that table which contains the data that you wish to join. |
A join is possible when the current table, or one of its columns, uses a Class or ID domain that is also used either by the selected table or by one of the columns in the selected table. The two tables or their columns thus need to use a common Class or ID domain. This is called the key: a link between the two tables can be established so that a join can take place.
Tip: Experienced users may also join columns from other tables by typing an expression on the TabCalc command line. For more information, see Table calculation : joining columns from other tables. This topic also provides some examples, both for using the wizard and for using the command line.
See also: