title: Update query MS Access join
body: <p>I have a query that pulls back 50 rows (which is correct):  </p>
  
  <pre><code>select * from [Review Results], [Specialist Name Table]   
  where [Authorizer Manager Name] = 5 
  and [Specialist Name Table].[Penson Analyst] = TRUE
  and [Review Results].[Authorizer Name] = [Specialist Name Table].[ID]
  </code></pre>
  
  <p>I'm trying to make an update query out of the above but i cannot seem to get this correct. This is the query that I am using however it wants to update 461 rows opposed to 50:  </p>
  
  <pre><code>update
  [Review Results] e
  INNER JOIN [Specialist Name Table] s ON  e.[Authorizer Name] = s.[ID]
  set e.[Authorizer Manager Name] = 5
  where s.[Penson Analyst] = TRUE  
  </code></pre>
  
  <p>Can anyone help out?</p>