--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

>
> At 12:45 PM 27/10/2005 +0200, Martijn "Bamsemums" Tonies wrote:
>
> > > select c.contactno from contacts c
> > > join gifts g where g.contactno = c.contactno
> > > where
> > > c.state in (1,2)
> > > and g.someotherfield = 'somvalue'
> > > group by contactno
> > > having sum(giftvalue)>100
> >
> >Well, at least we all agree to the solution on this one ;-)
>
> Almost - but you didn't spot Dmitry's deliberate error, did you? :-

))

>
> ./h
>

Yes I spotted it:

join gifts g ON ...
not ... WHERE ...