SQL Server - CROSS JOIN
What is CROSS JOIN in SQL Server ?
CROSS JOIN makes the cross relation between two or more table. It return the combination of all rows from both table.
If we have two table one table having three record and another table having two record and when we apply CROSS JOIN on both table it will return six rows.
Consider the below result.
Syntax of Self Join
Note : In CROSS JOIN we not use the ON keyword because CROSS JOIN multiply the record from both table.
Apply CROSS JOIN on above result set.