title: How to update multiple tables at the same time?
body: <p>I'm trying to update fields from three different tables but I'm getting some errors: </p>
  
  <pre><code>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'
  </code></pre>
  
  <p>And the errors:</p>
  
  <pre><code>Msg 102, Level 15, State 1, Line 2
  Incorrect syntax near ','.
  </code></pre>