Fabrice Vendé wrote:

> This don't work on firebird 1.5 but worked fine on firebird 1.0X :
>
> select count(distinct(ACTIONS.ac_code)) as NOMBRE
> from actions Q0
> ...
> where ...
> order by q0.ac_Date_prevu DESC

The query will return a single number, there is nothing to "order".


{When using an alias (Q0) you should always use the alias (like: Q0.ac_code)}



--
Aage J.