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
Next TopicSQLite Date and Time




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials

Computer Graphics Tutorial

C. Graphics
Automata Tutorial

Automata
Software Testing Tutorial

Testing
Numpy Tutorial

NumPy
Verbal Ability

Verbal A.
AWS Tutorial

AWS

Preparation

Aptitude

Aptitude
Logical Reasoning

Reasoning
Verbal Ability

Verbal A.
Interview Questions

Interview

B.Tech / MCA

DBMS tutorial

DBMS
Data Structures tutorial

DS
DAA tutorial

DAA
Operating System tutorial

OS
Computer Network tutorial

C. Network
Compiler Design tutorial

Compiler D.
Computer Organization and Architecture

COA
Discrete Mathematics Tutorial

D. Math.
html tutorial

Web Tech.
Cyber Security tutorial

Cyber Sec.
C Language tutorial

C
C++ tutorial

C++
Java tutorial

Java
.Net Framework tutorial

.Net
Python tutorial

Python
List of Programs

Programs
Control Systems tutorial

Control S.