87

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

The “STUDENT” table is having the following data:

The “DEPARTMENT” table is having the following data:

---