Hello,



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.



I'm using Microsoft access with odbc-connection (Gemini 2.1) I need both
fields. When I remove the sorting-feature on the second field (Firma), then
it is okay. But it doesn't sorting by "firma". I think, firebird sorting
automatically since firebird 2.0, but in this case, it won't working.



How can I sorting the second column in my query without this error?



Thanks in advance.







[Non-text portions of this message have been removed]