SQL Overview

Whether you build your queries using Guided Query or the CREATE function, your query uses the same SQL clauses. These clauses instruct CA Dataquery to search a table, limit the search, join one or more tables to the first table, group data, sort the data for presentation, and perform mathematical functions.

CA Dataquery SQL queries are English-like clauses whose keywords are SELECT, FROM, WHERE, HAVING, GROUP BY, and ORDER BY. These clauses together form an SQL SELECT statement. The UNION keyword can be used to combine SELECT statements. Also, SQL clauses can use the same basic elements, like expressions and search conditions.

For complete details on creating SQL statements for CA Dataquery, see the following pages.

For a tutorial on the basics of SQL query creation, see the CA Dataquery User Guide.

Note: Only one SQL command is allowed per query.