SQLite Forum

LEFT JOIN Misunderstanding
Login
There's lots of choices. If you look at what I did you can see why I might do that.  You can do something else you like that highlights which conditions go with which.  I'm pretty good at reading this stuff and I found it very hard to follow yours.  Adopt what you like but you have room to take advantage of more indenting.  You could keep the each ON clause separate but indented. You could break at each AND.  There's lots of good choices here but you need to be able to see which predicate goes with which clause at a glance, that helps a lot.