SQL Cross Join
When each row of first table is combined with each row from the second table, known as Cartesian join or cross join. In general words we can say that SQL CROSS JOIN returns the Cartesian product of the sets of rows from the joined table.
We can specify a CROSS JOIN in two ways:
SYNTAX of SQL Cross Join
Let us take an example of two tables,
Table1 - MatchScore
Table2 - Departments
After executing this query , you will find the following result: