Grouping conditional statements
In an advanced database query, it is required 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:
- Access the Query Builder. See Accessing the Query Builder.
- Click the Conditions tab and add all conditional statements.
- For the first condition of the group, click in the opening parenthesis symbol “(“ column.
- For the last condition of the group, click in the closing parenthesis symbol “)” column.
- Repeat until all desired grouping is in place. Sublevels of grouping are possible, but can be confusing. Every subsequent condition is applied as a sublevel of the condition preceding it.
To remove the group from conditional statements:
- For the first condition of the group, click next to the opening parenthesis symbol “(“.
- For the last condition of the group, click next to the closing parenthesis symbol “)”.
- Modify connectors as required. See Query Builder Statement Connectors