Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Is this JOIN good ?
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 Received on Mon Oct 16 2006 - 09:41:04 CDT