Example: Cross Model Join Implicit

This scenario merges the three input tables and returns all row combinations from the records of the inputs.

Input Tables
Material Table
Material Code Material Cost per Order Unit
M1011 Leather 10 USD
M1012 Thread 5 USD
Product Table
Product Code Product
P0001 Shoe
P0002 Watch
Order Table
Branch Order
BR001 10
BR002 20
Interim Result of Material Table and Product Table (MatPro Table)
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.

Expected Result
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.