Subject Re: Performance troubles
Author steffengrondahl
--- In, Ali Gökçen <alig@e...> wrote:
> select contactno from contacts c
> where state in(1,2)
> 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

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