Source: cirosantilli/update-with-join-sql

= UPDATE with JOIN
{c}
{disambiguate=SQL}

Dumping examples under \a[nodejs/sequelize/raw/many_to_many.js].

Not possible without subqueries in the standard syntax, a huge shame: https://stackoverflow.com/questions/1293330/how-can-i-do-an-update-statement-with-join-in-sql-server

The `UPDATE` + `FROM` extension exists in a few <DBMS>s:
* <PostgreSQL>: https://stackoverflow.com/questions/7869592/how-to-do-an-update-join-in-postgresql
* <SQLite>: https://stackoverflow.com/questions/19270259/update-with-join-in-sqlite/69831549#69831549

<ORM>:
* <Sequelize>: <UPDATE with JOIN in Sequelize>

Back to article page