Helen,

H> HAVING is not valid except with respect to GROUP BY.

not only is it valid, it's the only way to filter by an aggregate
expression when you don't have a group by clause.

Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================