Creating a Join condition for a database join.
You can perform a join on two tables using the Join operator.
Perform this task in the
Join Properties dialog box.
Prerequisites
You must have two tables in your workflow that can be joined. You must have specified the properties in the
Join operator
Properties dialog box.
Procedure
-
From the Join operator Properties dialog box, click
Define Join Conditions.
The
Join Properties - Database dialog box is displayed.
-
If an existing Join condition exists, deselect it by clicking
Clear.
-
Select the options to add for the new join condition.
-
Set
Left Table first.
Note:
- For different join types, the same table can appear only once on the right side of
JOIN CONDITIONS.
- When the selected
Join Type is
CROSS JOIN or
FULL OUTER JOIN, there are no join conditions.
Copyright © Cloud Software Group, Inc. All rights reserved.