Well, it's time to wait for Arno to reply then :-)

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

> Firebird version is 1.52.
>
>
> Can you do a GROUP BY ..., Base17
> R : Don´t work too...
> ----- Original Message -----
> From: Martijn Tonies
> To: firebird-support@yahoogroups.com
> Sent: Monday, September 05, 2005 11:49 AM
> Subject: Re: [firebird-support] Subselect error
>
>
>
>
> > It´s result in other error : "Cannot use an aggregate function in a

GROUP

> BY clause"
>
> Hmm... what version of Firebird?
>
> Can you do a GROUP BY ..., Base17