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