|
|
|
|
|
|
Category: Operations on queries |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
A query created in the query editor can contain several types of items...
|
|
|
|
|
|
|
When several data files are used in a query, the query editor automatically searches for the links between these files described in the analysis...
|
|
|
|
|
|
|
In the result of a select query, you have the ability to only display...
|
|
|
|
|
|
|
The query editor allows you to easily handle the queries.
|
|
|
|
|
|
|
The query editor allows you to perform operations on the values of an item...
|
|
|
|
|
|
|
The following paragraphs present...
|
|
|
|
|
|
|
The query editor allows you to optimize the execution speed of one or more queries...
|
|
|
|
|
|
|
When a "Date" item is found in the query, you have the ability to only select the records corresponding to a given period...
|
|
|
|
|
|
|
The selection conditions of records are applied to the items used in the queries...
|
|
|
|
|
|
|
When at least two selection conditions are found in a query, the sequence of selection conditions must be specified by the conditional operators AND and OR...
|
|
|
|
|
|
|
To make the result of a query easier to read, the records can be sorted according to one or more items...
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|