Question on foreign keys
I have a question regarding foreign keys. I have two tables the first has a primary key on staffid and the second has a foreign key referencing staffid from the first table. I also need to have the fields fname and lname from the first table updated in the second table when the field staffed is changed in the second table. I am a complete noob at sql and I just cant figure it out so I have turned to a forum to seek help on this issue.
Subject
Written By
Posted
Question on foreign keys
March 30, 2017 03:01AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.