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)
>     );

Great, that works fine.

pc_id is not important.

Thanks for your quick help!

A.

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