Hi, can I group two update statements into one query?
J John Vinson Apr 27, 2005 #3 Hi, can I group two update statements into one query? Click to expand... 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, can I group two update statements into one query? Click to expand... 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]
O Ofer Apr 27, 2005 #4 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
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
