OurBigBook About$ Donate
 Sign in+ Sign up
by Ciro Santilli (@cirosantilli, 37)

DELETE with JOIN (SQL)

 ... Relational database Relational database management system SQL SQL keyword UPDATE (SQL) UPDATE with JOIN (SQL)
 0 By others on same topic  0 Discussions  Updated 2025-06-12  +Created 1970-01-01  See my version
Tags: DELETE
Demo under: nodejs/sequelize/raw/many_to_many.js.
NO way in the SQL standard apparently, but you'd hope that implementation status would be similar to UPDATE with JOIN, but not even!
  • PostgreSQL: possible with DELETE FROM USING: stackoverflow.com/questions/11753904/postgresql-delete-with-inner-join
  • SQLite: not possible without subqueries as of 3.35 far: stackoverflow.com/questions/24511153/how-delete-table-inner-join-with-other-table-in-sqlite, Does not appear to have any relevant features at: www.sqlite.org/lang_delete.html
ORM
  • Sequelize: no support of course: stackoverflow.com/questions/40890131/sequelize-destroy-record-with-join

 Ancestors (14)

  1. UPDATE with JOIN (SQL)
  2. UPDATE (SQL)
  3. SQL keyword
  4. SQL
  5. Relational database management system
  6. Relational database
  7. Type of database
  8. Database
  9. Software
  10. Computer
  11. Information technology
  12. Area of technology
  13. Technology
  14.  Home

 View article source

 Discussion (0)

+ New discussion

There are no discussions about this article yet.

 Articles by others on the same topic (0)

There are currently no matching articles.
  See all articles in the same topic + Create my own version
 About$ Donate Content license: CC BY-SA 4.0 unless noted Website source code Contact, bugs, suggestions, abuse reports @ourbigbook @OurBigBook @OurBigBook