SQL Problem

[manfred_h]

Hallo zusammen

SQL-Code:

SELECT D_DATE, BIBLE_TYPE, AMOUNT
FROM NURSING_H_DD
   INNER JOIN NURSING_H_D ON (NURSING_H_DD.ID_D = NURSING_H_D.ID)
WHERE D_DATE BETWEEN '01.01.2000' AND '01.01.2008'
GROUP BY BIBLE_TYPE

kann mir jemand sagen wieso GROUP BY BIBLE_TYPE nicht geht?

erhalte immer folgende Fehlermeldung:

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause).


Danke für Eure Tips
Shalom
Manfred