title: UPDATE query with multiple INNER JOINs (syntax error)
body: <p>I'm trying to run an update query with multiple join statements in VBA, but I keep getting "missing operator" errors. Same happens when I try to run the SQL in query builder. The SQL is:</p>
  
  <pre><code>UPDATE TBL_DocReview_SingleStudy
  INNER JOIN TBL_LOA
  ON TBL_LOA.MemberName = TBL_DocReview_SingleStudy.Member
  INNER JOIN TBL_STUDY
  ON TBL_STUDY.StudyName = TBL_DocReview_SingleStudy.Study
  SET TBL_DocReview_SingleStudy.DateLOA2 = TBL_LOA.Status
  WHERE TBL_STUDY.CDB = 'B'
  </code></pre>
  
  <p>Can anyone see what I'm doing wrong?</p>