Query Overview

A query is a request for information from a database that is based on specific conditions. You can use a query to create custom data queries on data from the data sources available to CDM and retrieve the results into a report. The query can then be inserted into an Excel object.

When querying relational data sources, you retrieve data through SELECT statements. However, you can also use other query commands against the database, as permitted by the data source provider.

Important: The advanced functionality for Microsoft™ products is beyond the scope of this guide. However, some topics are included for your convenience. For more information, see Microsoft documentation or Microsoft online help.