Make complex database structure easy for building SQL queries (English)
Active Database Software, announced the release of a new version of Active Query Builder for .NET, a component for building SQL queries, which significantly improves the view and performance of metadata when building queries.
Automatic Joins Creation
Active Query Builder automatically determines relationships between tables and creates appropriate joins for them.
Different Join Types
Active Query Builder allows to define different join types and various server-specific query options visually.
Unions and Sub-Queries
Unions, sub queries and derived tables can be accessed and built visually in Active Query Builder as easy as the main query.
Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.