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;
