Cross Join
A cross join returns the Cartesian product of two sets of data. A Cartesian product is the set of all possible ordered pairs between the two inputs.
When configuring the Join processor to perform a cross join, you do not specify the join criteria used to perform the join.
When the Join processor performs a cross join on our sample data, the processor produces the following output:
| customer_id | customer_name | customer_id | order_id | amount |
|---|---|---|---|---|
| 2 | Anna Smith | 2 | 1075623 | 34.56 |
| 47 | Raquel Trujillo | 2 | 1075623 | 34.56 |
| 98 | Theo Barnes | 2 | 1075623 | 34.56 |
| 2 | Anna Smith | 47 | 1076645 | 234.67 |
| 47 | Raquel Trujillo | 47 | 1076645 | 234.67 |
| 98 | Theo Barnes | 47 | 1076645 | 234.67 |
| 2 | Anna Smith | 342 | 1050945 | 126.05 |
| 47 | Raquel Trujillo | 342 | 1050945 | 126.05 |
| 98 | Theo Barnes | 342 | 1050945 | 126.05 |