title: Expected SET in UPDATE statement H2 DB error code: 42001
body: <p>I'm currenlty trying to execute the following statement I found on the internet to change a snapshot from Sonar.</p>
  
  <pre><code>UPDATE snapshots as old_snap, 
         snapshots as new_snap 
  SET old_snap.islast = 0 
  where old_snap.islast=1 
  and new_snap.created_at &gt; old_snap.created_at 
  and new_snap.project_id = old_snap.project_id 
  and new_snap.islast=1;
  </code></pre>
  
  <p>But when executing the statement it says it expects a SET.</p>
  
  <blockquote>
    <p>Error: Syntax error in SQL statement "UPDATE SNAPSHOTS AS
    OLD_SNAP,[*]NEW_SNAP  SET OLD_SNAP.ISLAST = 0 WHERE OLD_SNAP.ISLAST=1
    AND NEW_SNAP.CREATED_AT > OLD_SNAP.CREATED_AT AND NEW_SNAP.PROJECT_ID
    = OLD_SNAP.PROJECT_ID AND NEW_SNAP.ISLAST=1 "; expected "SET"; SQL statement: UPDATE snapshots as old_snap,new_snap  SET old_snap.islast
    = 0 where old_snap.islast=1 and new_snap.created_at > old_snap.created_at and new_snap.project_id = old_snap.project_id and
    new_snap.islast=1 [42001-178] SQLState:  42001 ErrorCode: 42001</p>
  </blockquote>
  
  <p>Anyone who can fix this statement? </p>