SQLite Forum

LEFT JOIN Misunderstanding
Login
If you *want* to filter 'a' using 'f' then by all means keep it in the WHERE.