Example: Cross Model Join Implicit
This scenario merges the three input tables and returns all row combinations from the records of the inputs.
|
|
|
| Material Code | Material | Cost per Order | Unit | Product Code | Product |
|---|---|---|---|---|---|
| M1011 | Leather | 10 | USD | P0001 | Shoe |
| M1012 | Thread | 5 | USD | P0001 | Shoe |
| M1011 | Leather | 10 | USD | P0002 | Watch |
| M1012 | Thread | 5 | USD | P0002 | Watch |
Returns material code M1011 and M1012 for product code P0001.
Returns material code M1011 and M1012 for product code P0002.
The Cross Join produces an interim result set which is the number of rows in the first table multiplied by the number of rows in the second table.
| Material Code | Material | Cost per Order | Unit | Product Code | Product | Branch | Order |
|---|---|---|---|---|---|---|---|
| M1011 | Leather | 10 | USD | P0001 | Shoe | BR001 | 10 |
| M1011 | Leather | 10 | USD | P0001 | Shoe | BR002 | 20 |
| M1011 | Leather | 10 | USD | P0002 | Watch | BR001 | 10 |
| M1011 | Leather | 10 | USD | P0002 | Watch | BR002 | 20 |
| M1012 | Thread | 5 | USD | P0001 | Shoe | BR001 | 10 |
| M1012 | Thread | 5 | USD | P0001 | Shoe | BR002 | 20 |
| M1012 | Thread | 5 | USD | P0001 | Watch | BR001 | 10 |
| M1012 | Thread | 5 | USD | P0002 | Watch | BR002 | 20 |
The Cross Model Join produces a result set which is the number of rows in the interim table result multiplied by the number of rows on the third table.
In this result, we are identifying the number of orders, per product and per branch by cross referencing from Material Table to Product Table and Order Table.