Tables
Table 1: Foods
ItemId |
ItemName |
ItemUnit |
CompanyId |
1 |
Mixing |
Pcs |
16 |
2 |
Bananas |
Pcs |
15 |
3 |
Munching |
Pcs |
17 |
4 |
Basmati Rice |
Pcs |
15 |
5 |
Cheese Cake |
Pcs |
18 |
6 |
Brie Cheese |
Pcs |
NULL |
7 |
Salt & Pepper Chips |
Pcs |
15 |
Table 2: Orders
CompanyId |
CompanyName |
CompanyCity |
18 |
Kellog |
Florida |
15 |
Nestle |
Paris |
16 |
Trader Joe |
Denver |
17 |
Wegmans |
New York |
19 |
Bits and Bytes |
Buenos Aires |
Note: There is no order in which the CustomerID = 1 (Alfreds Futterkiste).
Query
SELECT Foods.ItemName, Foods.ItemUnit, Company.CompanyName, Company.CompanyCity FROM Foods CROSS JOIN Company;
Result
ItemName |
ItemUnit |
CompanyName |
CompanyCity |
Mixing |
Pcs |
Mixing |
Florida |
Bananas |
Pcs |
Mixing |
Florida |
Munching |
Pcs |
Mixing |
Florida |
… |
|||
Mixing |
Pcs |
Trader Joe |
Denver |
Bananas |
Pcs |
Trader Joe |
Denver |
Munching |
Pcs |
Trader Joe |
Denver |
… |