OurBigBook About$ Donate
 Sign in+ Sign up

 UPDATE with JOIN (SQL)

ID: update-with-join-sql

 Top articles Latest articles+ New article in topic
UPDATE with JOIN (SQL) by Ciro Santilli 37  Updated 2025-05-26  +Created 1970-01-01
Dumping examples under nodejs/sequelize/raw/many_to_many.js.
Not possible without subqueries in the standard syntax, a huge shame: stackoverflow.com/questions/1293330/how-can-i-do-an-update-statement-with-join-in-sql-server
The UPDATE + FROM extension exists in a few DBMSs:
  • PostgreSQL: stackoverflow.com/questions/7869592/how-to-do-an-update-join-in-postgresql
  • SQLite: stackoverflow.com/questions/19270259/update-with-join-in-sqlite/69831549#69831549
ORM:
  • Sequelize: UPDATE with JOIN in Sequelize
 Read the full article
Total articles: 1

 New to topics? Read the docs here!

 About$ Donate Content license: CC BY-SA 4.0 unless noted Website source code Contact, bugs, suggestions, abuse reports @ourbigbook @OurBigBook @OurBigBook