Dmitry,

The problem is not related to the aliases. The problem is in the
CASE item. If I takes if off the Group clause, the query works, but
it is very necessary in may query.

Thanks,

Marco Castro

--- In firebird-support@yahoogroups.com, Dmitry Yemanov <dimitr@...>
wrote:

>
> Marco Castroo wrote:
> >
> > In FireBird 1.5 I have a query with a group like this
> >
> > ...
> > Group by ae.Author, l.Book, Price,
> > case
> > When op.StockChange in (23,24) Then 21
> > When op.StockChange in (43,44) Then 22
> > Else Mode end
> > ...
>
> Could you please show us the entire query? Could "Price" or "Mode"

be

> column aliases for any aggregate functions used in the select list?
>
>
> Dmitry
>