How to work with subqueries in Active Query Builder ASP.NET Edition?
Last modified:
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:
Or you can do the same using the dropdown toolbar which appears on mouse hover on the query navigation bar:
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:
After that, it will be available for designing visually on the navigation bar: