OurBigBook About$ Donate
 Sign in Sign up

DELETE with JOIN (SQL)

Ciro Santilli (@cirosantilli, 37) ... Relational database Relational database management system SQL SQL keyword UPDATE (SQL) UPDATE with JOIN (SQL)
Updated 2025-07-16  0 By others on same topic  0 Discussions Create my own 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