Here is my error message:
(SQR 5528) ORACLE OCIStmtExecute error 979 in cursor 2:
ORA-00979: not a GROUP BY expression
SQL: SELECT DISTINCT wpymar1_pidm, spriden_last_name, spriden_first_name,
spriden_mi, spriden_id, (SELECT sum(cm.tbraccd_amount) FROM tbraccd cm,
tbbdetc WHERE tbbdetc_type_ind = ‘C’ AND cm.tbraccd_detail_code =
tbbdetc_detail_code AND t.tbraccd_pidm = cm.tbraccd_pidm GROUP BY
cm.tbraccd_pidm), (SELECT sum(pm.tbraccd_amount) FROM tbraccd pm,
tbbdetc WHERE tbbdetc_type_ind = ‘P’ AND pm.tbraccd_detail_code =
tbbdetc_detail_code AND t.tbraccd_pidm = pm.tbraccd_pidm GROUP BY
pm.tbraccd_pidm) FROM wpymar1 LEFT JOIN tbraccd t ON wpymar1_pidm =
t.tbraccd_pidm LEFT JOIN spriden ON t.tbraccd_pidm = spriden_pidm AND
spriden_change_ind is null WHERE spriden_last_name < 'Galzo' AND
spriden_last_name >= ‘Gallaghe’ GROUP BY wpymar1_pidm,
spriden_last_name, spriden_first_name, spriden_mi, spriden_id ORDER BY
spriden_last_name, spriden_first_name, spriden_mi, spriden_id
Error on line 136:
(SQR 3716) Error in SQL statement.
Just WHAT is not a GROUP BY expression?