SQLite Forum

LEFT JOIN Misunderstanding
Login
> "equijoin (inner join)"

An equijoin is not an INNER JOIN. You can do an INNER JOIN ON inequality if you want, and it won't be considered an equijoin.


> "It is useless for INNER joins and serves no useful purpose whatsoever."

The usefulness of always using the ANSI syntax is that if you switch your INNER JOIN over to an LEFT JOIN you're not left confused with why it didn't immediately work. 

It also serves to document your intent to the next person who reads your code.