How can I Insert Data into Foreign Key Table using sql Query?

Question

I have two tables in database 'Reservation' and 'Guest' contain one to many relationship.I want to insert data into Guest Table where Particular Reservation No in Reservation Table..i am using sql and jsp for doing this.plzzzzzzzzz help me urgent

Answer 1

Sample SQL Code to manage one-to-many data in your SQL

http://blog.pengoworks.com/index.cfm/2011/5/18/Easily-managing-onetomany-data-in-your-SQL-database-with-using-multiple-INSERT-INTO-statements

Answer 2

Sql Insert Foreign Key

Answer 3

Hi,



Refer to the below link



http://stackoverflow.com/questions/1997998/insert-data-into-tables-linked-by-foreign-key



http://aadseducation.com/

Answer 4

INSERT INTO Lib2(Book_id) SELECT Book_id FROM Lib1

Answer 5

mn