> Is it possible to do something like the following :
>
> SELECT A, SUM(B) FROM XYZ WHERE SUM(B) BETWEEN 10 AND 20 ?

SELECT
A,
SUM(B)
FROM XYZ
GROUP BY A
HAVING SUM(B) BETWEEN 10 AND 20


HTH,
Thomas Steinmaurer

The IB LogManager Product Family
Logging/Auditing Suite for InterBase and Firebird
http://www.iblogmanager.com