CROSS JOIN

The CROSS JOIN keyword returns all records from both tables (table1 and table2). The CROSS JOIN is used to generate a paired combination of each row of the first table with each row of the second table. This join type is also known as cartesian join.

Example 1:

SELECT * FROM [dbo].[Pets]
	CROSS JOIN [dbo].[Owners]

Example 2:

SELECT * FROM Meals 
CROSS JOIN Drinks