Working with Derived Tables

A Derived Table is a sub-query used as a datasource for the main query.

To add a derived table, you should right-click on the Query Building Area and select the Add Derived Table item from context popup menu.

A new object representing the newly created derived table will be added to the query building area, and the corresponding tab will be created for it. This tab allows you to build it visually in Building a single query as the main query.

Right-click on the Query1 table in the Main window and select Properties.

Change the name to something suitable as an alias.

Another way to switch to the corresponding derived table tab is to right-click at the caption of an object representing the derived table and select the Switch to derived table item from context popup menu.

You can always get back to the main query or switch to any sub-query or derived table using the tabs next to the Main tab or using the Navigating the Query Tree .