I have 3 table.
Table 1 & 2 are master tables. And 3 is the transaction table.
Table 3 has 2 foreign keys, each are the primary keys of 1 & 2.
So, when i create the third table in SQL, what command should i use???
CREATE TABLE registration
(student_id NUMBER(6) NOT NULL,
module_id NUMBER(6) NOT NULL,
campus CHAR(2),
semester VARCHAR2(10),
CONSTRAINT reg_tbl
FOREIGN KEY (student_id)
REFERENCES student(student_id)
FOREIGN KEY (module_id)
REFERENCES module(module_id));
I tried the above one, but it was wrong. Any idea of the right one???
Thanks