title: Updating a table by referencing another table
body: <p>I have a table <code>CustPurchase</code> (name, purchase) and another table <code>CustID</code> (id, name).  </p>
  
  <p>I altered the <code>CustPurchase</code> table to have an <code>id</code> field. Now, I want to populate this newly created field by referencing the customer ids from the <code>CustID</code> table, using:</p>
  
  <pre><code>UPDATE CustPurchase
     SET CustPurchase.id = CustID.id 
   WHERE CustPurchase.name = CustID.name;
  </code></pre>
  
  <p>I keep getting syntax errors! </p>