SQLite JOIN clause is used to combine two or more tables in a database. It combines the table by using the common values of the both table.
There are mainly three types of JOINS supported in SQlite:
- SQLite INNER JOIN
- SQLite OUTER JOIN
- SQLite CROSS JOIN