Re: help please

Thank You Yosi, that worked.

Joe

Yosi Greenfield <ygreenfield_at_compuserve.com> wrote in message news:381769C5.C43999FA_at_compuserve.com...
> Add the line
>
> Group by store_id
>
> to the end of the query. When you request a column and a group function,
> you've got to tell Oracle to group by the column.
>
> HTH,
>
> Yosi
>
>
> Joe D wrote:
>
> > I have this query:
> >
> > SQLWKS> select store_id Store, sum(amount+freight) Total from
> > REPORT_TRANSACTION_VIEW
> > 2> where TRANSACTION_DATE >= 936158400 and TRANSACTION_DATE <=
> > 938664000
> > 3> and transaction_type = '1'
> > 4> and STORE_ID =
> > 5> (select store_id from STORE SS where SS.KEY_STORE_SEQID =
> > 6> (select V.KEY_STORE_SEQID from REPORT_STORES_VIEW V where NAME =
> > 'Tiger Toy Store'))
> > 7> ;
> >
> > When I run it, I get this error:
> >
> > and STORE_ID =
> > *
> > ORA-00937: not a single-group group function
> >
> > how do I fix this? I want the output to include the store_id field.
> >
> > TIA
> >
> > Joe D
>
Received on Wed Oct 27 1999 - 17:03:53 CDT