SQLite Forum

LEFT JOIN Misunderstanding
Login
That is true.  

An INNER join only includes in the projection results rows which pass all constraints.

An OUTER join includes in the projection results all rows from the specified table in the projection and uses one ALL NULL record for non-matched constraints (LEFT / RIGHT / FULL -- means both).