title: How do I perform update query with subquery in Access?
body: <p>I want to port this SQL query, which works just fine on SQL Server, MySQL, and Oracle, to an Access database.  How do I do that?  <del>Right now it prompts me for a Company_ID for some reason.</del></p>
  
  <p><strong>Edit</strong>: I was getting the prompt because I forgot to first create the Company_ID column in VendorRegKeys.  Now I am getting error "Operation must use an updateable query".</p>
  
  <pre><code>UPDATE VendorRegKeys
     SET Company_ID = (SELECT Users.Company_ID
                       FROM Users
                       WHERE Users.User_ID = VendorRegKeys.CreatedBy_ID)
  </code></pre>
  
  <hr>
  
  <p><strong>Update</strong>: I found this to work based on <a href="https://stackoverflow.com/users/123759/juniorflip">JuniorFlip</a>'s answer:</p>
  
  <pre><code>UPDATE VendorRegKeys, Users
  SET VendorRegKeys.Company_ID = Users.Company_ID
  WHERE VendorRegKeys.CreatedBy_ID = Users.User_ID
  </code></pre>