title: Inner Join Query in Access2013 SQL view
body: <p>I have two tables in access 2013"2017FrenchProjectData" and "NewModes" I am trying to use the 'invoicemode / service level' column that is in both fields to update the 'French Project Mode' that is only in the New Modes table. I am using the below however i keep getting a syntax error (missing operator) message.</p>
  
  <pre><code>UPDATE     [2017FrenchProjectData]
  SET        [2017FrenchProjectData].[FrenchProjectMode]=newmodes.[frenchprojectmode]
            ,[2017FrenchProjectData].[BasicMode]=[newmodes].[modedesc]
  FROM       [2017FrenchProjectData]
  INNER JOIN NewModes 
  ON         2017FrenchProjectData.[ Invoice Mode / Service Level]=Newmodes.[ Invoice Mode / Service Level]
  </code></pre>