title: operation must use an updateable query - access
body: <p>I want to update a table by using the join in access - 2007</p>
  
  <pre><code>UPDATE TABLE1 A INNER JOIN (SELECT ACCODE, SUM(AMOUNT) AS SUM_AMOUNT 
  FROM TABLE2 GROUP BY ACCODE) B ON A.ACCODE = B.ACCODE
  SET A.TRIAL = A.TRIAL + SUM_AMOUNT
  </code></pre>
  
  <p>it gives me error that </p>
  
  <blockquote>
    <p>operation must use an updateable query</p>
  </blockquote>
  
  <p>i have try with below query and no error is here</p>
  
  <pre><code>UPDATE TABLE1 A INNER JOIN TABLE2 B ON A.ACCODE = B.ACCODE
  SET A.TRIAL = A.TRIAL + SUM_AMOUNT
  </code></pre>
  
  <p>please help me to find what is wrong with first query</p>