title: Update SQL Table with INNER
body: <pre><code>UPDATE SAP_FBL3N_MAIN
  INNER JOIN SAP_FCHN_MAIN ON  (SAP_FBL3N_MAIN.[Check number] =  FCHN.[Check number from to] AND SAP_FBL3N_MAIN.[Type] = 'ZA'  AND SAP_FBL3N_MAIN.[Account]='105010' AND SAP_FCHN_MAIN.[Acct ID]='APIMM')
  
  SET SAP_FBL3N_MAIN.&quot;MatchingStatus&quot; = ('Cleared_SAP'+ CONVERT(varchar(256),SAP_FBL3N_MAIN.[ID]))
      ,SAP_FBL3N_MAIN.&quot;MatchingTimeStamp&quot;= GETDATE()
      ,SAP_FCHN_MAIN.&quot;MatchingStatus&quot; = ('Cleared_SAP' + CONVERT(varchar(256),SAP_FBL3N_MAIN.[ID]))
      ,SAP_FCHN_MAIN.&quot;MatchingTimeStamp&quot; = GETDATE();
  </code></pre>
  <p>Throwing Error ,
  Msg 156, Level 15, State 1, Line 2
  Incorrect syntax near the keyword 'INNER'.</p>