Join Properties - Database Dialog Box

From the Team Studio Join operator, specify settings to join multiple datasets that are stored in a database.

Join Properties: Selected Columns for Output Table
Setting	Description
Output Table	This section reflects the number of fields specified for the join output.
Selected Columns for Output Table	From the list, select check box for the columns to include in the output table. You can select any individual, all, or no columns from an individual input table. The input tables' names are enclosed in brackets immediately before the column name.
Input Tables	You can filter for a specific table using the all and none controls for columns listed under Selected Columns for Output Table.

Join Conditions / Create Join Condition
Setting	Description
Left Table	To create or update a join condition, you must specify a left table from the drop-down list box. The available tables are those listed under Input Table.
Join Type	From the drop-down list box, specify the join type. Available SQL join types are: JOIN LEFT JOIN RIGHT JOIN FULL OUTER JOIN CROSS JOIN Join Type Note: If you are creating a multi-condition join, leave Join Type blank.
Right Table	From the drop-down list box, select the table to join to the Left Table. A right table should be specified only once per join operator. If you are joining on multiple conditions, the right table must be specified only once. If you are joining more than two tables, a right table can appear only once in the join conditions.
Column1	From the drop-down list box, select the column from the Left Table on which the join is performed.
Condition	From the drop-down list box, select the join condition between Column1 and Column2.
Column2	From the drop-down list box, select the column from the right table on which the join is performed.
Multi-Connection	If more than one join condition is necessary, from the drop-down list box, select AND or OR to combine with the following join condition.