Hi Elmar,

Thanks for the reply. I guess it doesn't make a difference if you sort on MAX(aField) or the field itself?, because the MAX of a field for each record is the field value itself.

Best regards, Nico



nico_callewaert@... schrieb:

> group by hi_bkj,
> hi_drk,
> kl_nam
> order by hi_bkj,
> hi_net desc,
> hi_drk
>
> Was working under IB 5.6

What did IB 5.6 do there?

The Group-By does create tuples (hi_bkj,hi_drk,kl_nam) these cannot be
ordered by hi_net since this is undefined (there might be multiple
he_net values associated to each tuple!

As an alternative you might try to sort by "min(hi_net)" or
"max(hi_net)" whatever meets your requirements.

Elmar