co_ador — 2011-04-08T14:14:27-04:00 — #1
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?
r937 — 2011-04-08T14:31:22-04:00 — #2
one at a time
and by the way, it is customer (a patron; one who purchases or receives a product or service from a business or merchant), not costumer (a person who designs, makes or supplies theatrical costumes; a costumier)
co_ador — 2011-04-08T14:36:06-04:00 — #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.