• Conditional AND operator: the selected records will match both conditions. For example, select the customers whose name starts with the letter "A" AND who live in London.
• Conditional OR operator: the selected records will match one of the two conditions or both conditions. For example, select the customers who live in London OR in New York.

• 1st method: via the description window of query.
• 2nd method: from the graphic representation of query.

Modifying the sequence of selection conditions in a select query

1. Display the popup menu of the query (right click) and select the "description of the query" option. The query description window appears.
2. Click the "Selection condition" button and select "Existing conditions".
3. Modify the sequence of selection conditions.
4. Validate. The modification is automatically performed in the query.

Modifying the sequence of selection conditions in an update query or in a delete query

1. Display the popup menu of the query (right click) and select the "description of the query" option. The query description window appears.
2. Select the "And/Or" tab.
3. Modify the sequence of selection conditions.
4. Validate. The modification is automatically performed in the query.

Modifying the sequence of selection conditions from the graphic representation of the query

1. Select the selection condition whose sequence must be modified in the graphic representation of the query.
2. Select "Reverse AND/OR" from the popup menu (right mouse click) of the current selection condition.
3. The new sequence of selection conditions is automatically applied to the query.