Re: Is this JOIN good ?

From: David Portas <REMOVE_BEFORE_REPLYING_dportas_at_acm.org>
Date: 17 Oct 2006 02:09:43 -0700
Message-ID: <1161076183.667798.61110@f16g2000cwb.googlegroups.com>

DA Morgan wrote:

> If A.FK and B.FK are both lookups to tables holding the same set of
> values I'd say you have a design flaw.

My interpretation of Charles's post was that he assumed both foreign keys were referencing the SAME table, namely table C. I agree that the OP didn't make it clear.

> Well that and the fact that you can not write a foreign key to two
> different tables from the same column.

Why not? Are you referring to some limitation of Oracle or is that just your recommendation?

-- 
David Portas

Received on Tue Oct 17 2006 - 04:09:43 CDT