SQL

When the Query Builder creates a query, uses a special language called “SQL” to carry out the query. SQL stands for “Structured Query Language.” It is the industry standard database language. This means that you can do even more powerful querying by directly entering your own SQL statements.

SQL Commands. A detailed explanation of SQL is beyond the scope of this manual. If you are interested in doing more powerful querying of your database, refer to an SQL manual. You should be able to find plenty of information on the Internet.

Entering SQL Commands. When the query builder creates a query, the combined query statement appears in an Edit Box entitled “Query Parameters”. This statement is used as the "Where" clause in a standard SQL "Select" command. This means that you can edit this text and create your own "Where" clause of virtually unlimited complexity.