how to insert data into multiple table in sql?

Question

i want to insert data into multiple table by single insert statement.can i do so?plz help me.........

Answer 1

First you have to join those two tables by using foreign key..



after that insert all your data's in that first table that should be updated in other table also with that foreign key(we already assigned)

Answer 2

Make the column which u have to insert as primary and create a table which acts as a secondary which is linked by foreign key and insert into ur values in the first table thus u can update the second table also:-)

Answer 3

you need to join the tables for updating them together and inserting data at once.

Answer 4

yes it can be but let me see . i will tell u tomorrow it's using oracle 9i multitable cocept

Answer 5

sophisticated issue. look into in google. that will might help!

Answer 6

You can't do it.