--- In firebird-support@yahoogroups.com, Ali Gökçen <alig@e...> wrote:

>
> select contactno from contacts c
> where state in(1,2)
> AND
> exists(select sum(giftvalue)
> from gifts
> where contactno = c.contactno
> and someotherfield = 'somevalue'
> having sum(giftvalue)>=100
> )
>
> My "AND" eaten by some by some brain bugs.
>

Thanks but it doesn't seem to work fast enough. So I keep to the other
suggestions.

It seems like firebird prefers joins made with explicitely use of join
rather than the implicit call in my code and the code above.