Grouping Conditional Statements

In an advanced database query, it may be necessary to not only use multiple conditions, but also to group those conditions together so that more complex searches can be performed.

To group conditional statements

1. Open the Query Builder.

2. Click the Conditions tab and add all conditional statements.

3. For the first condition of the group, click the Add (+) button in the opening parenthesis symbol “(“ column.
4. For the last condition of the group, click the Add (+) button in the closing parenthesis symbol “)” column.
5. Repeat until all desired grouping is in place. Sublevels of grouping are possible, but may be confusing. Every subsequent condition will be applied as a sublevel of the condition preceding it.

To remove the group from conditional statements

1. For the first condition of the group, click the Remove (-) button next to the opening parenthesis symbol “(“.
2. For the last condition of the group, click the Remove (-) button next to the closing parenthesis symbol “)”.

3. Modify connectors as necessary.

Related Topics

Query Builder Conditions

Query Builder Overview