I have an UPDATE query which performs several opertions in one table. UPDATE table01 SET field1 = (query1 may contain any field), field2 = (query1 may contain any field), field3 = (query1 may contain any field) WHERE (condition)
query1, query2 and query3 perform a logic to determine which records will be updated. Does field1 updates first, then field2 and, lastly, field3? or What is the order in which updates are executed? If I need fields to be updated in a certain order, should I use 3 UPDATE commands instead? Respectfully, Jorge Maldonado
