User's Guide

Adding a derived table

Index  Previous  Next

You may add a derived table (a sub-query used in the FROM clause) using the Query Building Area.

To add a sub-query, right click on the Query Building Area and select the Add Derived Table item from the drop-down menu.

A new object representing the newly created derived table will be added to the query building area of the main query. In addition, the corresponding tab will be created after adding the derived table. This tab allows you to edit the sub-query visually in the same way as you edit the main query. Another way to switch to the sub-query tab is to press the maximize button at the header of the object representing this derived table.

Index  Previous  Next