Re: Multiple keys?

On Wednesday 28 August 2002 06:22 am, Richard Poole wrote:
> 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.

Hmm, that's a problem :\.  See I want the table to be constrained by a unique
combination of the three, but I want the second table to be constrained by a
unique combination of only the two, as the third column is not present in the
second table.

I'm uncertain what to do, but I thank you for pointing out my error in
overconstraining the first table.

--
Casey Allen Shobe / Network Security Analyst & PHP Developer
SecureWorks, Inc. / 404.327.6339 x169 / Fax: 404.728.0144
cshobe@secureworks.net / http://www.secureworks.net
Content is my own and does not necessarily represent my company.

"Diagoras the Atheist once visited Samothrace and a friend there said to him,
'You think the gods have no care for humans?  Why, you can see from all these
votive pictures here how many people have escaped the fury of storms at sea
by praying to the gods, who have brought them safe to harbour.'  'Yes,
indeed,' said Diagoras, 'but where are the pictures of all those who suffered
shipwreck and perished in the waves?'  On another occasion he was on a voyage
and the crew became anxious about the bad weather and began to mutter that it
served them right for taking an atheist on board.  Diagoras just pointed out
to them a number of other ships on the same course which were in equal
difficulties and asked them whether they thought that there was a Diagoras on
the passenger-list of every one of them.  The fact is that a man's character
or way of life makes no difference at all to his good luck or bad."

- Cicero