title: Update values in one table from three other joined tables in H2 (and DB2)
body: <p>I'm trying to achieve something like described here in H2:</p>
  
  <p><a href="https://stackoverflow.com/questions/2849534/update-with-inner-join">Update with inner join?</a></p>
  
  <p>update tlegacy lca
  set 
        lca.pr_dato = ca.calc_holdings_date<br>
  ...
  from tca ca inner join tdd dd on ...</p>
  
  <p>and I get Error: Column "CA.CALC_HOLDINGS_DATE" not found in H2.</p>
  
  <p>The "missing" field is ofcourse present. I've tried a number of variants with no luck. Does H2 support this way of updating values in one table collected from a number of other joined tables? Eventually this should run on IBM DB2. Is it supported there?</p>