SQLite Forum

LEFT JOIN Misunderstanding
Login
"INNER JOIN" + WHERE is how one does an equijoin.  It works, it has always worked, and there is no other alternate specification.

"LEFT JOIN" + WHERE does actually work and do EXACTLY what you specified by done.  It is true that the partial descent specifier must be specified in the ON clause (in these modern times -- generally because the kidz were otherwise confused) for the outer join case and that the WHERE clause only applies to the final projection, but this is as things have been since the beginning times.

The real problem is that many people "say what they habit" rather than "say what they mean".  They are in love with "LEFT JOIN" because they heard it once and thought it was cool, so now they use it ALL THE TIME, even when it does not apply, because, OH BOY does it sound COOL!

This is the problem with children today.  They saw it on TV once and without actually understanding what they are doing, just try to copy "the cool kidz", because, hey, its so cool!