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

Subscribe to our newsletter
Partners

Firebird 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