SQL: CROSS JOIN

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]
Next Recommended Reading Self Joins in SQL Server