Specifies the conditions on a database join between two tables.
This function is used as the I/O expression of the element that contains the data to be written. It specifies which columns are to be joined between the parent and child tables. It also specifies any selection criteria for the join.
This function can only be used in the IO/Database tab.
Arguments
| Parent Elements (Columns) | Specify the map elements corresponding to the columns in the parent table to be joined. These must be in the same order as the child elements. |
| Child Elements (Columns) |
Specify the map elements corresponding to the columns in the child table to be joined. These must be in the same order as the corresponding parent elements. |
Properties
| Where Condition | Enter a SQL condition as specified in a Where clause without the use of the word "Where". |
| Join Type | Select Inner to have the join exclude rows from the parent table with no corresponding rows in the child table. Select Outer to have all rows in the parent table included whether or not they are in the child table. |