title: how to add column to the table from another table by join
body: <p>I want to add column from another table by join.
  I want initial table to be updated with one column from another table. when im doing this it returns me SQL command not properly ended.
  I have a query:</p>
  
  <pre><code>update final_tableau 
  set final_tableau.Mobile_flag = credit_mobile.Mobile_flag
  from final_tableau a left join credit_mobile b 
  on a.client_pin = b.client_pin
  </code></pre>