Hi,

> I'm using FB 1.5. Both queries are identical, having identical WHERE
> and HAVING clauses.

As meantioned by Alexandre in FB1.5 the where clause on views which contain an aggregate query (or
union) is evaluated after the view is processed. FB2.0 will try (not always possible) to move the
where clause on the view into the where clause inside the view.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
General database development support:
http://www.databasedevelopmentforum.com

Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Firebird and Interbase users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info