Active Query Builder  »  User's Guide  »  Building a query with sub-queries

User's Guide

Working with derived tables

Index  Previous  Up  Next

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

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

Adding a derived table

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 the same way as the main query. Another way to switch to the corresponding derived table tab is to right click the caption of an object representing the derived table and select the "Switch to derived table" item from the context popup menu.

You can set an alias for the derived table the same way as for ordinary database object.

You can always go back to the main query and switch to any sub-query or derived table using tabs above the Query Building Area or using the Query Structure Tree.

Getting access to a derived table

Index  Previous  Up  Next




We have been using Active Query Builder for over a year and must say that both the product and support have been outstanding!

We chose Active Query Builder due to its flexibility and features, but have been truly pleased by its power and hidden capabilities. ...

In summary Active Query Builder provides excellent components, great support and a very flexible feature set. It has allowed us to provide features to our end users that I did not think would be possible in the first release of our new tools and in a timeframe that was much shorter than planned. I would recommend that anyone dealing with databases in the .Net world should be aware of this component and its capabilities!

Social networks