Screenshots

Working with Unions, Sub queries and Derived tables

Unions, sub queries and derived tables can be accessed and built visually in Active Query Builder as easy as the main query.

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

Unions are managed within the Union Panel at top-right the corner of the query building area, so you can build a query with unions in 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 appropriate nodes from the tree.


All screenshots

Related pages

News

Testimonial

With users expecting better and better interfaces to deal with complex data retrieval, Active Query Builder has allowed me to provide a highly professional, robust environment to both novice users and skilled query writers.

Thanks to all the team involved. Please keep up the good work.
CodeGear - Where Developers Matter