A new improvement in SQL query generation allows you to get complete and correct data. To do this, we firstly join data from different tables and then apply filters ‘WHERE’ to the resulting data.
How it used to work before
While generating an SQL query, we would add filters ‘WHERE’ to each ‘SELECT’ from tables. Here’s an example:
According to the new logic, we add filters at the end of the query after all the joins. See the example below:
Now you will definitely trust your reports built on complete data.