help please

From: Joe D <joed_at_icoms.com>
Date: Wed, 27 Oct 1999 17:10:23 -0400
Message-ID: <381769d3@News.Destek.net>

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 - 16:10:23 CDT