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

User's Guide

Navigating the query tree

Index  Up  Next 

The Query Structure Tree represents the query structure in compact tree-like form. By using it, you can jump to any Union, Sub-query, Derived table or CTE and to any part of the query with a single mouse click. This feature is extremely useful in case of complex SQL queries.

By setting the appropriate component's options you can set up the tree to hide unnecessary nodes. For example, you can hide Objects and/or Expressions nodes and show only sub-queries structure of the query.

Query Structure Tree

Index  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