• 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.

Conditional AND operator	Conditional OR operator

• 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. Right-click to open the context menu of the query and select "Query description". 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. Right-click to open the context menu of the query and select "Query description". 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. Right-click the current selection condition and select "Reverse AND/OR" in the context menu.
3. The new sequence of selection conditions is automatically applied to the query.