Re: ORA-00979: not a GROUP BY expression - can someone help?

Opps...

 Thanks for the help Pankaj.

pankaj_wolfhun..._at_yahoo.co.in wrote:
> Mohd Al Junaibi wrote:
> > Hello all,
> >
> >
> > I'm receiving a ORA-00979 (NOT A GROUP BY Expression) error when I try
> >
> > to run the below statement:
> >
> >
> > SELECT APPLICATIONAUTH.APP, APPLICATIONAUTH.GROUPNAME,
> >
> >
> > ( sum(decode(optionname,'READ',1,'INSERT',3,'DELETE',5,'SAVE',7) ) )
> > As authCalc,
> >
> >
> > MAXAPPS.DESCRIPTION
> > FROM APPLICATIONAUTH, MAXAPPS
> > WHERE APPLICATIONAUTH.APP = MAXAPPS.APP
> > GROUP BY APPLICATIONAUTH.APP, APPLICATIONAUTH.GROUPNAME
> >
> >
> > Can someone help me? I'm new to Oracle, and I think it is a silly
> > mistake.
>
> You forgot to include MAXAPPS.DESCRIPTION in GROUP BY clause.
> It should be
>
> SELECT APPLICATIONAUTH.APP, APPLICATIONAUTH.GROUPNAME,
> ( sum(decode(optionname,'READ',1,'INSERT',3,'DELETE',5,'SAVE',7) ) )
> As authCalc,
> MAXAPPS.DESCRIPTION
> FROM APPLICATIONAUTH, MAXAPPS
> WHERE APPLICATIONAUTH.APP = MAXAPPS.APP
> GROUP BY APPLICATIONAUTH.APP, APPLICATIONAUTH.GROUPNAME,
> MAXAPPS.DESCRIPTION
Received on Wed Jan 03 2007 - 23:33:17 CST