Active Query Builder support area

How to work with subqueries in Active Query Builder ASP.NET Edition?

Last modified:

Dashboard Knowledge Base

To add a derived table, a named sub-query to CTE or unite several SELECT statements with set operators like UNION, you can right click on the design pane and use the context menu:

Image 31

 

Or you can do the same using the dropdown toolbar which appears on mouse hover on the query navigation bar:

Image 32

BTW, all subqueries are displayed on this toolbar after their addition to the query.

 

The only type of subquery which you currently should add by typing is subquery in SQL expressions (in the SELECT and WHERE parts). You can type only a template of such subquery:

Image 33

 

After that, it will be available for designing visually on the navigation bar:

Image 34


Is this article helpful for you?