Re: Locating all Children given Set of Parents

On 05/13/03 09:47:46 -0700 Josh Berkus wrote:

> Select children.*
> from children where exists (select pc_id
>     from parent_child
>     where pc.child_id = children.id
>     and pc.parent_id IN ($parent_id_list)
>     );

What is "pc_id" referring too?

Thanks,

A.

--
Adam Sherman
Tritus CG Inc.
http://www.tritus.ca/
+1 (613) 797-6819