title: Coldfusion ORM update with Join
body: <p>I am looking for help on a HQL-statement, where I would like to do an update with a JOIN. I tried following statement, which runs fine in MySQL-Workbench:</p>
  
  <pre><code>UPDATE table1 t1 
  SET    t1.status='Running' 
  JOIN   t1.table2 t2  
  WHERE  t1.status='Open' AND t2.destination ='mydestination' "
  </code></pre>
  
  <p>but it gives the error: </p>
  
  <blockquote>
    <p>expecting "set", found 'JOIN' near line 1, column 16</p>
  </blockquote>