Re: [SQL] 7.1 REFERENCES contstraints

2001-05-06 Thread Stephan Szabo
On Sun, 6 May 2001, Michael Richards wrote: > I see that the REFERENCES constraint is a little more restrictive in > 7.1. I need to have a table with a constraint so one of it's columns > must exist in a second table. This is not a key, since there may be N > columns in the second table that m

[SQL] 7.1 REFERENCES contstraints

2001-05-06 Thread Michael Richards
I see that the REFERENCES constraint is a little more restrictive in 7.1. I need to have a table with a constraint so one of it's columns must exist in a second table. This is not a key, since there may be N columns in the second table that match. Any ideas on how I should create this? CREATE