title: Update with inner join Postgresql
body: <p>Because doing this update does not work for the where clause? The update does it for me all.</p>
  
  <pre><code>UPDATE ventas SET eav_id = 7 
  FROM ventas AS A
  inner join ventasDetalle AS e on A.act_id = e.act_id and e.exp_id = A.exp_id
  where a.eav_id = 1
  </code></pre>