Javatpoint Logo
Javatpoint Logo

SQLite 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:

Image Representation:

Sqlite Cross join 1

We have two tables "STUDENT" and "DEPARTMENT".

Sqlite Cross join 2

The "STUDENT" table is having the following data:

Sqlite Cross join 3

The "DEPARTMENT" table is having the following data:

Sqlite Cross join 4

Example:

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

Sqlite Cross join 5




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA