klabu wrote:
> Assuming you don't know anything about these 3 tables beyond FK & PK
>
> select *
> from A, B, C
> where A.fk = C.pk
> and B.fk = C.pk
>
> Is this JOIN "complete" ?
> or an additional predicate is needed between A and B ?
>
>
> thanks
Based upon what you posted I would say that it is impossible to tell.
Is a.fk the child of c.pk? I don't know.
Is b.fk the child of c.pk? I don't know.
And even if they are ... it is impossible to know if these single
relationships are sufficient to avoid a Cartesian product.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Oct 16 2006 - 10:20:48 CDT
