two statements in one?

  • Thread starter Thread starter js
  • Start date Start date
Hi, can I group two update statements into one query?

Only one UPDATE clause, but that clause can update many fields: e.g.

UPDATE mytable
SET thisfield = <something>,
thatfield = <something else>,
anotherfield = <whatever>
WHERE <criteria>

John W. Vinson[MVP]
 
Hi js
You can join together only quries that return records, ""Select queries
you can't join update query together, you wont see them in the list of
quries and tables to select from
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top