Update with inner join Postgresql

Viewed 10205

Because doing this update does not work for the where clause? The update does it for me all.

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
2 Answers
Related