> So for learning sake, is there a tool that converts a query using `WHERE` to a query (that yields identical results) using JOINs?
I'm not aware of a tool, but I would assert that not using a tool is for learning sake. Recoding by hand is going to be your best learning experience. Note: there was a lot of good reading in the links you provided. One went right down in logical order how Select statement is evaluated by SQL engines. That there is the greatest tool for learning sake. On Fri, Mar 1, 2019 at 2:15 AM Rocky Ji <[email protected]> wrote: > In SQL world, generally > <https://stackoverflow.com/questions/5273942/mysql-inner-join-vs-where>, > not just SQLite > < > https://www.mail-archive.com/[email protected]/msg114165.html > >, > a lot <https://stackoverflow.com/questions/121631/inner-join-vs-where> of > pros say that the constructs `from...inner join...on` and `from...where` > are equivalent > <https://stackoverflow.com/questions/1018822/inner-join-on-vs-where-clause > >, > and that query optimizer should build identical plans for either variant. > > Understanding `WHERE` is simple / straight-forward / intutive, to those > 1. without mathematics background, or > 2. used to imperative code and for-loops > > So for learning sake, is there a tool that converts a query using `WHERE` > to a query (that yields identical results) using JOINs? Like a English -> > <AnyLanguage> side-by-side translator. > > Cheers > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
