title: MS-Access SQL Error (Update on an Inner Join with aggregate function)
body: <p>I have this SELECT query which works perfectly:</p>
  
  <pre><code>SELECT T1.Account, T1.Total, T2.Account, T2.Total
  FROM tSummary2 as T1
  
  INNER JOIN
  (SELECT tSummary2.Account, 
  Count(FinalData.ID) AS Total
  FROM tSummary2 
  INNER JOIN FinalData 
  ON tSummary2.Account = FinalData.Account
  GROUP BY tSummary2.Account) as T2
  
  ON T2.Account = T1.Account
  </code></pre>
  
  <p>I need to make T1.Total = T2.Total.
  But every attempt to turn this into an update query is failing with "SYNTAX ERROR (missing operator).</p>
  
  <p>Here is what I am trying:</p>
  
  <pre><code>UPDATE T1
  SET T1.Total = T2.Total
  FROM tSummary2 as T1
  
  INNER JOIN
  (SELECT tSummary2.Account, 
  Count(FinalData.ID) AS Total
  FROM tSummary2 
  INNER JOIN FinalData 
  ON tSummary2.Account = FinalData.Account
  GROUP BY tSummary2.Account) as T2
  
  ON T2.Account = T1.Account
  </code></pre>
  
  <p>What am I missing?</p>