I have manually printed out all the combinations in example containing three tables with respective values for the understanding.
Table1 Table2 Table3
a1 b1 c1
a2 b2 c2
The results should be as follow
We will use Cartesian Join or Cross Join for the solution of above example. Cross Join returns the Cartesian product of rows from tables in the join. Each row in the first table is matched with every row in the second table and so on.
select * from table1 cross join table2 cross join table3Same thing as implicit cross join:
select * from table1, table2, table3