Error in SQL query (SQL update) : <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>
