I want to build a composite primary key made up of foreign keys from two different tables. I'm still pretty green to this…
A great answer was given to building a composite key from multiple foreign keys on this question but I want to do this from multiple tables. I am using Oracle 11g.
foreign key (Name, BoughtFrom, TimeBought) references the_other_table_name (Name, BoughtFrom, TimeBought)
Imagine that the "references" line actually includes multiple tables. I'm not even sure that the above syntax will work with Oracle.
I have one table "Student" and one table "Parent". It is a many-to-many relationship. My association table is named "Relation" and I would like to make a composite primary key from "PAR_ID" and "STU_ID". Both are foreign keys.