Built-In Query Designer

Easy to use query designer makes building complex queries a snap.  Includes joining tables, grouping, sorting and search criteria.  You will find yourself using the query builder for all your SQL select statements.

Select table from which to query.

Select the desired table field to query.

Create calculated field including custom expressions.

Specify any grouping for an aggregate query.

Select field search criteria.

Select and order the fields by which you want the results sorted.

View resulting SQL syntax you generated in seconds.

SQL code appears in ExpressSQL Query window ready to run or save.

Comments are closed