jeudi 15 mai 2014

updating two table with one single insert-SQL


Vote count:

0




Is it possible to make the following two querries to one single query?



update customers set customer_name = 'John' where customer_id=1;

update purchases set state='Accepted' where customer_id=1;

customer(table)
--------
customer_id(PK)
customer_name



purchases(table)
---------
customer_id(FK)
product
state


Thanks



asked 29 secs ago






Aucun commentaire:

Enregistrer un commentaire