Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: Insert into two or more tables?


Message #1 by "Jake C" <jakeone@b...> on Wed, 21 Mar 2001 11:39:46
Hi there, 

Is it possible to insert data into two different, but related, tables 
simultaneously around a join?

i.e.  I want to do something like...

INSERT INTO table1, table2 (values for table1, values for table2) INNER 
JOIN ON table1ID = table2ID.

I don't know if this is even possible!

Thanks for any help you can give.

Jake


  Return to Index