Re: Database query with subselect

From: Amit K <amit.kulkarni_at_zensar.com>
Date: 10 Feb 2004 19:54:48 -0800
Message-ID: <2bc535e8.0402101954.16fbeaeb_at_posting.google.com>

theodor_ramisch_at_hotmail.com (Theodor Ramisch) wrote in message news:<12a479ae.0402100650.de612ba_at_posting.google.com>...
> Hi there,
>
> I've got a simple table with an ID and a parentID field which build the relation
> between the entries. Now I want to select some entries and count their childs.
>
> This is what I tried:
>
> SELECT NAME, ID, parentID,
> (SELECT COUNT(ID) FROM myTable WHERE parentID=???ID???)
> AS CHILDS FROM myTable WHERE parentID=0 ORDER BY parentID ASC
>
> My problem is how to tell oracle to use the ID of the current entry in the
> main query, not the ID field in the subselect.
>
> Can anybody help me?
>
> Thanks,

---

Use the aliases thr
like FOM myTable A etc
and then use A.ID in select

it will work
> Theodor
Received on Wed Feb 11 2004 - 04:54:48 CET