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