Question

What is SQLite OUTER JOIN?

Answer 1

There are three types of OUTER JOINS:

• Left outer join
• Right outer join
• Full outer join

But SQLite only supports left outer join. The SQLite left outer join returns all rows from left table and only those rows from the right table where the join condition is satisfied.

Syntax:

SELECT ... FROM table1 LEFT OUTER JOIN table2 ON conditional_expression