> in Firebird 1.5 this is not a problem:
>
>
>
> SELECT TLIEFERANTEN.LIID, TLIEFERANTEN.FIRMA
>
> FROM TLIEFERANTEN
>
> GROUP BY TLIEFERANTEN.LIID, TLIEFERANTEN.FIRMA
>
> ORDER BY TLIEFERANTEN.FIRMA;
>
>
>
> Since Firebird 2 I got an error message .. Ambiguous field name between a
> field and a field in select list.

Is it your real command ? It does work for me on FB2.1.1

Ivan