unknown Token DESC

[haentschman]

Danke für die Anteilnahme

IBExpert:

Delphi-Quellcode:

select PAYMENT_DATE, sum(PAYMENT), 'dummy' as CAPTION, ID_PAYMENT_TYPE from PAYMENTS where ID_PROCESS in (select ID_PROCESS from PROCESSES where ID_STORE = 2) group by PAYMENT_DATE, ID_PAYMENT_TYPE

...funktioniert -> Ergebnismenge

Delphi-Quellcode:

select * from(

select PAYMENT_DATE, sum(PAYMENT), 'dummy' as CAPTION, ID_PAYMENT_TYPE from PAYMENTS where ID_PROCESS in (select ID_PROCESS from PROCESSES where ID_STORE = 2) group by PAYMENT_DATE, ID_PAYMENT_TYPE

) order by PAYMENT_DATE, SUM desc

Fehler: Token unknown - line 1, column 241.desc.
...wie zu sehen ist, ist da nur ein zusätzliches select drumherum...

Zitat:

aber versucht doch mal SUM(Payment) statt einfach nur SUM

...mit weggelassenem SUM ...) order by PAYMENT_DATE bekomme ich einen Kommandofehler:
Invalid command.
no column name specified for column number 2 in derived table <unnamed>.