SQLite Forum

JOIN query behaves differently with/without trailing ON?
Login
Chronological Hierarchical 
You need to build from source.

   1.  Download the [Pre-release Snapshot][1]
   2.  Unarchive it
   3.  Unix → `./configure --enable-all && make`
   4.  Windows → `nmake /f makefile.msc`

[1]: https://sqlite.org/download.html