Choose your SQL server:
AnySQL
MySQL
MS SQL Server
PostgreSQL
Oracle
SQL Anywhere
DB2
SQLite
Firebird
MaxDB

Subscribe to our newsletter

MaxDB Code Factory online Help

Prev  Return to chapter overview Next 

Adding new group

Suppose we also need to select orders payed via 'Visa' or 'American Express'. This is a complex filter condition combining two simple conditions with the OR operator. So we cannot just add them at the same root level as for the existing conditions which are combined by an AND operator. Instead, we need to add a group of conditions. This can be done with the help of the Filter box for the SaleDate condition (select the Add Group menu item).

 



Prev  Return to chapter overview Next