--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> 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 ;-)
>
> With regards,
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle &

MS SQL

> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>

Thanks to all of you

Realizing my SQL skills could be better :o) In particular I've taken
notice of the 'join' and 'having' SQL commands. Nice. And performance
is now less than 10 s.

Regards

Steffen