What version of Oracle?
Jim
"Shoval Tomer" <shoval_at_softov.co.il> wrote in message
news:714a60c1.0207160409.4a3662b4_at_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 - 09:57:15 CDT
