Active Query Builder


Working with Unions, Sub-queries and Derived tables

Sub queries and derived tables are located on separate tabs so that they can be accessed and built visually as easy as the main query.

Unions are managed within the Union Panel at the top-right corner of the query building area so that you can build a query with unions in just a few clicks!

The Query Structure Tree at the left hand allows you to review the whole query structure at once and quickly access the needed sub-queries, objects and expressions by selecting the appropriate nodes from the tree.

All screenshots

Related pages




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