title: What is wrong with my SQL syntax for an UPDATE with a JOIN?
body: <p>I have two tables, related by a common key. So TableA has key AID and value Name and TableB has keys AID, BID and values Name, Value:</p>
  
  <pre><code>AID Name
  74  Alpha
  
  AID BID Name  Value
  74  4   Beta  Brilliance
  </code></pre>
  
  <p>I would like to update the TableB Value here from Brilliance to Barmy, using just the Name fields. I thought I could do it via an UPDATE containing a JOIN, but Access (I know...) is complaining with 'Syntax error (missing operator) in query expression ' and then everything from 'Barmy' here:</p>
  
  <pre><code>UPDATE tB
  SET tB.Value='Barmy'
  FROM `TableB` tB
  INNER JOIN `TableA` tA
    ON tB.AID=tA.AID
  WHERE tB.Name='Beta'
    AND tA.Name='Alpha';
  </code></pre>
  
  <p>What is my heinous crime? Or is it just Access not conforming?</p>