SQLite Forum

LEFT JOIN Misunderstanding
Login
FWIW, I much prefer [](https://sqlite.org/forum/forumpost/bd05c5ea6ee5fb91?t=h),  
i.e. `ON` should only be with columns from the 2 joined tables on both sides,  
and `WHERE` with only a single column from any table and a literal (typically).

The way you mix ON-predicates and WHERE-predicates in `ON` now,  
or everything in `WHERE` before, confuses things IMHO (and was wrong for the latter).

It's partly a matter of style.  
I like to think of it as `ON` being about *stitching tables* together, and `WHERE` about *filtering*.  
The former is also a *filtering* of sort, yet different in my mind. YMMV :)