GROUP BY ORA-00979: not a GROUP BY expression

[Stevennn]

I get this error when i try to run it ORA-00979: not a GROUP BY expression. I know that group by ,must include everything in SELECT. Still not working.
ANy ideas?

thank-you for the help

SELECT e.ar_ent,
a. ex_ent,
e.ar_cc,
c.cx_ctr,
e.ar_acc,
d.ax_acc,
e.ar_sa,
b.ss_sub,
sum (ar_amt) as AMT

FROM
F_test5 e,
D_test 1 a,
D_test 2 b,
D_test 3 c,
D_test 4 d
WHERE
(e.ar_ent = a.ex_ent and
e.ar_cc = c.cx_ctr and
e.ar_sa = b.sx_sub and
e.ar_acc = d.ax_acc)


GROUP BY
b.sx_sub, d.ax_acc, c.cx_ctr, a.ex_ent, ar_amt;

 

[SantaMufasa]

Russski,

The following SELECT expressions must appear in your GROUP BY expression list:

e.ar_ent, e.ar_cc, e.ar_sa, and b.ss_sub.


Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]