Can you not do
select partner.name,person.age
from partner,person
where partner.pid=person.pid
group by partner.name,person.age;
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Ralf Wegener" <rwegener_at_gmx.net> wrote in message
news:9lvsob$hrp$05$1_at_news.t-online.com...
> Hi,
>
> my problem:
>
> I would like to use a subquery within a group clause.
>
> Example:
>
> select partner.name, (select age from person where partner.pid=person.pid)
> from partner
> group by partner.name, (select age from person where
partner.pid=person.pid)
>
> I get the error:
>
> select partner.name, (select age from person where partner.pid=person.pid)
> from partner
> *
> ORA-00979: not a GROUP BY expression
>
> Any ideas?
>
>
> Best regards
>
> Ralf Wegener
>
>
>
>
Received on Wed Aug 22 2001 - 04:29:19 CDT
