CROSS JOIN is used to return all records where each row from first table is combined with each row in second table. It is also Known as Cartesian Product join. A CROSS JOIN can be specified in two ways:
1. Firstly, using the JOIN syntax
2. Secondly, by listing the tables in the FROM clause separated by commas without using a WHERE clause to supply join criteria.
Syntax:-
SELECT * FROM [TABLE 1] CROSS JOIN [TABLE 2]
OR
SELECT * FROM [TABLE 1], [TABLE 2]