Re: [sqlite] Is there a tool to convert `where`s to equivalent `join`s?

On Fri, 1 Mar 2019 13:44:57 +0530 Rocky Ji wrote: > 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 -> side-by-side translator. SQL-92 was introduced a long time ago. At that time, I don't

Re: [sqlite] Is there a tool to convert `where`s to equivalent `join`s?

> 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

[sqlite] Is there a tool to convert `where`s to equivalent `join`s?

In SQL world, generally , not just SQLite , a lot of pros say that the