Group by

From: Cor van Loon <vanloon_at_planet.nl>
Date: Fri, 13 May 2005 21:03:12 +0200
Message-ID: <d62u8p$e9k$1@reader11.wxs.nl>

Hi,

I''m converting a sql-statement with a 'group by' to Oracle 8i .

Select Tab1.f1, Tab1.fk,

(select field from Tab2 where tab2.pk=Tab1.fk) as description, count(*)
from Tab1
group by Tab1.f1, Tab1.fk

Oracle reports an error "ORA-00979 Not a GROUP BY expression" As soon as I remove the subquery the statements works fine (but is mis the value).
Does Oracle 8i accepts subqueries as expression in the select-part?

Kind regards,

Cor Received on Fri May 13 2005 - 14:03:12 CDT