In SQL world, generally
<https://stackoverflow.com/questions/5273942/mysql-inner-join-vs-where>,
not just SQLite
<https://www.mail-archive.com/sqlite-users@mailinglists.sqlite.org/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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
