Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
misty
Yak Posting Veteran
80 Posts |
 Posted - 2009-02-07 : 02:30:05
|
| Hi again. I'm working on oracle and I have created some tables. But in fourth table there is a mistake and I cant find. Please help.it says "no matching unique or primary key for this column-list" but i have checked all other tables and i have primary keys everywhere.create table m(k_m int not null,k_p int not null,k_ep int not null,k_t varchar(30) not null,name varchar(30),p_s number(3),foreign key k_p references p(k_p),foreign key k_ep references ep(k_ep),foreign key k_t references t(k_t),primary key (k_m,k_p,k_ep); |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-02-07 : 03:33:30
|
p_s number(3), ???
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
Assignment