title: SQL Updating from an inner join
body: <p>I'm using microsoft Access.</p>
  
  <p>If this query: </p>
  
  <pre><code>(SELECT FERMENT.FermentId
  FROM FERMENT
  INNER JOIN [BELGIUM BEER]
  ON
  FERMENT.FermentName = [BELGIUM BEER].FermentId ORDER BY [BELGIUM BEER].BeerId) a
  </code></pre>
  
  <p>returns FermentId, how do I update a different table with that column?</p>
  
  <p>Example:</p>
  
  <pre><code>UPDATE EXAMPLETABLE
  SET EXAMPLETABLE.FermentId = a.FermentId
  FROM a
  (SELECT FERMENT.FermentId
  FROM FERMENT
  INNER JOIN [BELGIUM BEER]
  ON
  FERMENT.FermentName = [BELGIUM BEER].FermentId ORDER BY [BELGIUM BEER].BeerId) a
  </code></pre>