Items used in a select query A query created in the query editor can contain several types of items... Joins between the data files of a select query When several data files are used in a query, the query editor automatically searches for the links between these files described in the analysis... Modifying the values displayed in the result of a select query In the result of a select query, you have the ability to only display... Opening, closing and saving a query The query editor allows you to easily handle the queries. Operations in a Select query The query editor allows you to perform operations on the values of an item... Operations in a Select query : add and delete The following paragraphs present... Optimizing the query execution The query editor allows you to optimize the execution speed of one or more queries... Query: Displaying the records corresponding to a given period When a "Date" item is found in the query, you have the ability to only select the records corresponding to a given period... Select query: Displaying the first/last n records The editor of Select queries is used to limit the number of records that will be displayed in the result of the query. Selection conditions of a query The selection conditions of records are applied to the items used in the queries... Sequence of selection conditions for a query 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... Sort order of records found in a select query To make the result of a query easier to read, the records can be sorted according to one or more items...