title: Postgresql Update with join
body: <p>I want to join 2 tables and update value of firts table on specified value of 2nd table. I failed using others solutions.</p>
  
  <pre><code>UPDATE customers
  SET cutoffstop = cutoffstop + '432000'
  FROM customers as c
  JOIN bluemedia as b ON c.id = b.customerid
  WHERE b.orderid = '217201807'
  </code></pre>