SQLite Joins

In SQLite, JOIN clause is used to combine records from two or more tables in a database. It unites fields from two tables by using the common values of the both table.

There are mainly three types of Joins in SQLite:

  • SQLite INNER JOIN
  • SQLite OUTER JOIN
  • SQLite CROSS JOIN

Example:

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

Sqlite Joins 1

The "STUDENT" table is having the following data:

Sqlite Joins 2

The "DEPARTMENT" table is having the following data:

Sqlite Joins 3




Latest Courses