Adam,
> > 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?
parent_child.id
Which column you use isn't important, just don't use "SELECT *"
--
-Josh Berkus
Aglio Database Solutions
San Francisco