SQLite Forum

LEFT JOIN Misunderstanding
Login
Yes.  And there is no DISTINCT and the projection result is not DISTINCT and may contain duplicate tuples.