Hi,



I'm afraid not. Generelly does orderby not work with group by.



Has anyone an idea?











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.firebird <http://www.firebirdsql.org> sql.org and click

the Resources item

> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoeni

<http://www.ibphoenix.com> x.com

>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>

Internal Virus Database is out of date.
Checked by AVG - http://www.avg.com
Version: 8.0.138 / Virus Database: 270.5.3/1564 - Release Date: 21.07.2008
06:42
Internal Virus Database is out of date.
Checked by AVG - http://www.avg.com
Version: 8.0.138 / Virus Database: 270.5.3/1564 - Release Date: 21.07.2008
06:42


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