Group selection made easy, Outer joins made powerful
Site owned & produced by MagnaFacta


In subqueries containing only FROM * as the table source we can leave this statement out.

No data source

Using the query:

"show the sales of departments selling apples"

We have shortened the original query by removing the second mention of FROM SalesOverview. Click on Generate to see the transformation.

Conditions of use, Copyrights © & Intellectual Property Rights