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