SQL CROSS JOIN
Each row of first table is combined with each row from the second table, known as Cartesian join or cross join.
SQL Cross Join Syntax
SELECT * FROM [TABLE1] CROSS JOIN [TABLE2] OR SELECT * FROM [ TABLE1] , [TABLE2]
Each row of first table is combined with each row from the second table, known as Cartesian join or cross join.
SELECT * FROM [TABLE1] CROSS JOIN [TABLE2] OR SELECT * FROM [ TABLE1] , [TABLE2]