<

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]  

















© copyright 2017-2022 Completedone pvt ltd.