title: Why does this UPDATE statement fail in H2?
body: <p>This UPDATE statement works when run against Postgres, but fails when run against H2. What's the equivalent H2 statement?</p>
  
  <pre><code>UPDATE award_details
  SET award_id = a.id
  FROM awards a
  WHERE a.award_details_id = award_details.id;
  </code></pre>
  
  <p>The H2 error message is:</p>
  
  <pre><code>SQL State  : 42000
  Error Code : 42000
  Message    : Syntax error in SQL statement "​​[*]
  UPDATE AWARD_DETAILS
  SET AWARD_ID = A.ID
  FROM AWARDS A
  WHERE A.AWARD_DETAILS_ID = AWARD_DETAILS.ID"; SQL statement:
  </code></pre>