Sql Excel : CROSSJOIN: Generating the Cartesian Product of Two Tables

The CROSSJOIN operator takes two inputs and combines them in a very specific
way. It produces a wider table that contains all the columns in the two inputs, the
Cartesian product of the two tables. Every row in the output corresponds to a pair
of rows, one from each input. For instance, if the first table has four rows, A, B, C,
and D, and the second has three rows, X, Y, and Z, then the output consists of all
twelve combinations of these: AX, AY, AZ, BX, BY, BZ, CX, CY, CZ, DX, DY, and
DZ. The CROSSJOIN is the most general join operation.