Active Query Builder » User's Guide » Building a query with sub-queries
User's Guide
Working with unions
Union sub-queries are managed within the Union Panel in the top-right corner of the Query Building Area. Initially there's only one union sub-query labeled with the "Q" letter. All required operations are performed by means of context popup menus.
Union sub-queries can be grouped with other sub-queries and joined with different operators (UNION, UNION ALL, EXCEPT, INTERSECT).
- To add a new union sub-query, select the New Union sub-query menu item.
- To enclose the sub-query in brackets, select the Enclose in Brackets menu item.
- To move the sub-query or bracket to the top of the query (the topmost sub-query is the left one), select the Move Left menu item.
- To move the sub-query or bracket to the bottom of the query, select the Move Right menu item.
- To remove the sub-query or bracket, select the Remove menu item.
- To change the union joining operator, select the necessary operator in the list of supported operators in the context popup menu.
Union Sub-Query operations:
|
 |
Operations with brackets:
|
 |
Select union joining operator |
 |
News
- 12/14/2023
Active Query Builder ASP.NET Edition 3.10 adds support for SignalR client-server communication
Support for SignalR lets use Active Query Builder in Blazor apps. - 09/20/2023
Active Query Builder VCL Edition 1.34 adds support for Snowflake and Firebird 4
New SQL Text editor API improvements and performance optimizations are made. - 04/11/2023
Active Query Builder VCL Edition 1.33 speeds up the SQL text editor
The new SQL filter builder control lets save user-defined filters between work sessions. - » Active Query Builder news
-
Subscribe
Testimonials
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!