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

Artificial Intelligence Tutorial

AI
Apache Spark Tutorial

Spark
Swift Tutorial

Swift
Apache Pig Tutorial

Pig
Flask Tutorial

Flask
Computer Graphics Tutorial

C. Graphics

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.
Ethical Hacking Tutorial

E. Hacking
html tutorial

Web Tech.
Cyber Security tutorial

Cyber Sec.
Automata Tutorial

Automata
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.