Re: HELP! - How to use combined key as foreign key in another table???
From: Roger Wernersson <roger.wernersson_at_adra.se>
Date: 1996/11/21
Message-ID: <32948235.4570_at_adra.se>#1/1
Date: 1996/11/21
Message-ID: <32948235.4570_at_adra.se>#1/1
Richard A Creed wrote:
> FOREIGN KEY (CourseID, LocationID, StartDate)
> REFERENCES Presentation
> );
>
> which doesn't work ...
Hello Richard!
Please try something like this:
ALTER TABLE one_table
ADD CONSTRAINT one_constraint
FOREIGN KEY (one_column, another_column)
REFERENCES another_table (this_column, that_column);
It might work.
/Roger Received on Thu Nov 21 1996 - 00:00:00 CET