I think I understand why this error would occur, but I do not understand why it is occuring with my query.
SUM(FIELD_5) AS CNT
FIELD_4 BETWEEN 200901 AND 201112
(FIELD_1 = '1029' AND FIELD_2 = '02' AND FIELD_3 IN ('489889','488332','489890','489870'))
(FIELD_1 = '5029' AND FIELD_2 = '01' AND FIELD_3 IN ('474812','474813'))
(FIELD_1 = '1029' AND FIELD_2 = '03' AND FIELD_3 IN ('489894'))
GROUP BY 1,2.3,4
ORDER BY 2,3,4,1
Any help would be greatlly appreciated.
The syntax of your Group By Clause is not correct. There is a "." instead of "," in between 2 & 3. Replacing the "." with "," will make it work.
GROUP BY 1,2,3,4