title: Update a column of one table with a column of another table
body: <p>I want to update one column of first table with another column of other table with this query:</p>
  
  <p>I need to update the both columns at a same time.</p>
  
  <pre><code>update tblMTD 
  set tblMTD.agedebt = OST.balance, OST.balance = '0'
  from tblMTD 
  inner join OST on tblMTD.sub = OST.sub
  </code></pre>
  
  <p>I get an error:</p>
  
  <blockquote>
    <p>Msg 4104, Level 16, State 1, Line 1<br>
    The multi-part identifier "OST.balance" could not be bound.</p>
  </blockquote>