Update Question 1

[Cloonalt]

Can I join three tables and update fields from all?

Thanks.

 

[SQLSister]

No, you should only update one table at a time. You need to update in a specific order usually as well as the primary table should be updated first.

You can update using a join to identify which records to update, but you will still only be updating one table at a time. Something like which would update the table with the alias of cg:

Update cg
set field1 = t.field2
from table1 cg join table2 t on cg.id_field = t.id_field
where t.someotherfield = 29

Questions about posting. See faq183-874
Click here to help with Hurricane Relief