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
Chapter 7 – Excel Query
Create Excel Query and update Query
This Microsoft Excel tutorial explains how to create Excel Query, create Join Table, update Query, add Query criteria.
You may also want to read:
Excel automatically select specific columns using Custom Views and Query
Microsoft Excel create Query
Similar to Microsoft Access Query, Excel allows users to create Query through graphical user interface, which means you don't need to have technical skills to write any SQL statement. Although Microsoft Excel has the capability to do that, Acce...
Read More