group by problem (ora-00979)

From: Shoval Tomer <shoval_at_softov.co.il>
Date: 16 Jul 2002 05:09:22 -0700
Message-ID: <714a60c1.0207160409.4a3662b4@posting.google.com>

trying to group by when the sub query has count(*) in it. This query works fine in SQL server, though.

select 	s.sndnam as Sender, s.sndcode as SenderCode, 	
        (select	count(*) from r  rRes,o  oRes,c  cRes 
	where	rRes.rordno = oRes.oordno  
	and  	rRes.rdate = oRes.odate and oRes.osndcod = s.sndcode
	and	cRes.ccode = rRes.rtest   and rRes.rresult='POSITIVE') as TotalPos
from  	s  ,  o  ,  r  ,  c  
where  	s.sndcode = o.osndcod  and  r.rordno = o.oordno  and  r.rdate = o.odate 
and	c.ccode = r.rtest   	

group by s.sndnam, s.sndcode            

Thanks Received on Tue Jul 16 2002 - 07:09:22 CDT