Olaf,

does 'order by 2' work for you?


Regards,

Robert Wagner


Olaf Kluge schrieb:

> 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]
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>