What is SQLite JOIN? How many types of JOINS are supported in SQLite?

SQLite - Interview Questions

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