Re: Multiple keys?

On Wed, Aug 28, 2002 at 02:10:44AM -0400, Casey Allen Shobe wrote:
> In order to get the foreign key I want working, I had to have two unique
> references on the parent table, though the second covers two columns that are
> contained within the first.  Is this wise?  Is there a better way?

Your two-column constraint, the one you need to add to get your foreign
key working, implies your three-column one. So you can just get rid of
the three-column one.

Richard