--- 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
>

Also,

would Firebird 2 not complain about an ambiguous field in the group
by? If it is going to get picky with the select, then surely it is
picky about group by ;)

Adam