Now, only amateur SQL query building tools don't have a visual SQL builder. Surely, you either already have such a tool or going to get one in the nearest future. Take a look at the available solutions. Are they really as convenient as they may seem? A visual query builder should help you to cope with the following tasks:
Active Query Builder successfully copes with both these tasks, and therefore it will help you to increase the range of potential users of your product! So stop loosing your customers, buy Active Query Builder now!
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.
Grouping, Sorting and Criteria
Active Query Builder allows to define grouping, sorting, and constructing criteria in a simple and direct way.
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.