Locating all Children given Set of Parents

From: Adam Sherman <adam(at)tritus(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Locating all Children given Set of Parents
Date: 2003-05-13 16:19:42
Message-ID: 184690000.1052842782@saturn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have three tables: parents, children & parent_child_mm.

(So Parents and Children are in a Many-to-Many relationship.)

Given a set of Parents, say 1, 2 & 3, how do I retrieve all children in an
efficient manner? (I want each child to appear only once.)

Thanks,

A.

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message chester c young 2003-05-13 16:33:16 Re: N all-way relationship
Previous Message Ryan 2003-05-13 14:16:31 N all-way relationship