Create Cartesian product with Excel Query

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

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