
This Excel tutorial explains how to create Cartesian product with Excel Query.
You may also want to read:
Microsoft Access create Cartesian product with Cross Join
Create Excel Query and update Query
Create Cartesian product with Excel Query
In SQL, there are several types of Table Join: Left Join, Right Join, Inner Join and Cross Join.
Cross Join is to produce all possible combination of records in joined Tables which are unrelated (without common key), the result is known as Cart...
Read More