SQLite Forum

LEFT JOIN Misunderstanding
Login
> 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!

Without contending that coolness is never a factor, I am sure I speak for more than a few SQL novices by saying: Sometimes, SQL constructs are used as a form of incantation, preferred because they are thought to summon satisfactory results rather than for their cachet.