CONNX Data Integration Suite 14.8.0 | InfoNaut - The Query Tool | Query Builder | Adding a Derived Table
 
Adding a Derived Table
Derived tables are a sub-query used in the FROM clause.
To add a derived table, right click in the Query Building Area and select Add Derived Table. The query building area now contains an object and a corresponding tab representing the newly created derived table. This tab allows you to edit the sub-query the same way as you edit the main query. Here is an example:The derived table object appears next to the previous object in the main Query Building Area. It is possible to edit the new object on it's own by selecting the newly made Query1 tab.
Another way to switch to the sub-query tab is to press the derived table's maximize button.