Results 1 to 3 of 3
Apr 8, 2011, 11:14 #1
INSERT data INTO two different table at once.
Is that possible. Have a costumers and product tables. at some point in the code it will have a Statement that will retrieve data from both table through a link table call costupro table with a costumer_id and product_id field. Now at the moment a costumer wants to insert data it is obvious that both tables costumers and product table will be used by the costumer to insert data in both. How a insert statement to two different is approached?
Apr 8, 2011, 11:31 #2
- Join Date
- Jul 2002
- Toronto, Canada
- 63 Post(s)
- 3 Thread(s)
Apr 8, 2011, 11:36 #3
thank you r937
I still have some miss spelling words to manage....
In my own humble opinion I think they should make the INSERT as the SELECT, the SELECT is capable of building longer statements.
thank you again I am going to go one at the time by now.