SQLite User Forum

LEFT JOIN Misunderstanding
Login
BTW good indenting reveals the structure of the query.  Bad indenting makes it harder to see what goes with what.  I would say the original version is bad.  Even if you don't like my version I'm sure you can do better.  But I wouldn't have spotted the fact that there is no `ON` for the `LEFT` on `F` in your version.