How to update multiple tables at the same time?

Question

I'm trying to update fields from three different tables but I'm getting some errors:

UPDATE    a, b, c SET    a.Locked = 0,    b.Locked = 0,    c.Locked = 0,    a.LockedByUsername = 'zolomon',    b.LockedByUsername = 'zolomon',    c.LockedByUsername = 'zolomon',    a.LockedAt = CURRENT_TIMESTAMP,    b.LockedAt = CURRENT_TIMESTAMP,    c.LockedAt = CURRENT_TIMESTAMP FROM    TableA AS a   INNER JOIN TableB as b ON n.Objid = o.Objid   INNER JOIN TableC as c ON n.Namnid = e.Namnid  WHERE   a.Namn1 = 'FirstName LastName' AND b.objektkod='SomeIdentifier' 

And the errors:

Msg 102, Level 15, State 1, Line 2 Incorrect syntax near ','. 

Answer 1

You can't update fields from multiple tables on a single update query. There error you are getting is because this is not permitted:

update a, b, c 

Since you can only update one table per update command.