The ability to JOIN multiple tables when using UPDATE

UPDATE foo
  SET a = bar.a,
      b = bar.b
FROM bar 
WHERE bar.f_id = foo.id;

(The above is PostgreSQL syntax)

Back to the SQL Feature Comparison