Cross Join

The SQLite Cross join is used to match every rows of the first table with every rows of the second table. If the first table contains x columns and second table contains y columns then the resultant Cross join table will contain the x*y columns.

Syntax:

SELECT ... FROM table1 CROSS JOIN table2   

Image Representation:

We have two tables “STUDENT” and “DEPARTMENT”.

The “STUDENT” table is having the following data:

The “DEPARTMENT” table is having the following data:

Example:

Select all records from tables STUDENT and DEPARTBMENT after cross join:

SELECT * FROM COMPANY CROSS JOIN DEPARTMENT;