title: Update MSAccess table from another Access table using SQL
body: <p>I am trying to update table Original with the values in Final. I'm a newb to SQL, but I have been at this for two hours trying to change various samples to fit my needs. I am using Access 2007.</p>
  
  <pre><code>UPDATE 
    Original o
  SET 
    o.[Assest Description] = (
      SELECT f.[Assest Description] FROM Original o, Final f 
      WHERE o.[Assest No] = f.[Assest No])
  WHERE o.[Assest No] = Final.[Asset No]
  </code></pre>