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?

one at a time :slight_smile:

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)

:slight_smile:

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.