what is a cross join tsql code example Example: sql cross join SELECT * FROM table1 CROSS JOIN table2;