title: Error in SQL query (SQL update)
body: <p>The query is :</p>
  
  <pre><code>Update t1
  set t1.paper_attempt = 1
  from table1 as t1
  JOIN table2 as t2
  ON t2.user_id = t1.user_id
  JOIN table3 as t3
  ON t3.id = t2.company_id
  where t3.candidate_id = 'CAND024';
  </code></pre>
  
  <p>I am using HeidiSQL, on running the query, it is showing a Syntax error. Please help!</p>