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:

1. Using the JOIN syntax.
2. the table in the FROM clause without using a WHERE clause.

SYNTAX of SQL CROSS JOIN:

Let us take an example of two tables,

Table1 - MatchScore

Table2 - Departments

SQL Statement:

After executing this query , you will find the following result: