PowerCenter
- PowerCenter 10.5.1
- All Products
{source1INNER JOINsource2onjoin_condition}
Syntax
| Description
|
---|---|
source1
| Source table name. The Integration Service returns rows from this table that match the join condition. |
source2
| Source table name. The Integration Service returns rows from this table that match the join condition. |
join_condition
| Condition for the join. Use syntax supported by the source database. You can combine multiple join conditions with the AND operator. |
|
|
|
---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
{ REG_CUSTOMER INNER JOIN PURCHASES on REG_CUSTOMER.CUST_ID = PURCHASES.CUST_ID }
|
|
|
|
|
---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|