Informatica Data Quality
- Informatica Data Quality 10.5.2
- All Products
{source1INNER JOINsource2onjoin_condition}
Syntax
| Description
|
---|---|
source1
| Source resource name. The Data Integration Service returns rows from this resource that match the join condition. |
source2
| Source resource name. The Data Integration Service returns rows from this resource 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 }
|
|
|
|
|
---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|