{disambiguate=SQL}
{c}
{tag=DELETE (SQL)}

Demo under: \a[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 (SQL)>, but not even!
* <PostgreSQL>: possible with `DELETE FROM USING`: https://stackoverflow.com/questions/11753904/postgresql-delete-with-inner-join
* <SQLite>: not possible without subqueries as of 3.35 far: https://stackoverflow.com/questions/24511153/how-delete-table-inner-join-with-other-table-in-sqlite[], Does not appear to have any relevant features at: https://www.sqlite.org/lang_delete.html

<ORM>
* <Sequelize>: no support of course: https://stackoverflow.com/questions/40890131/sequelize-destroy-record-with-join


DELETE with JOIN

DELETE with JOIN (SQL)

{disambiguate=SQL}
{c}

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>


Ciro Santilli @cirosantilli 37

 Incoming links: UPDATE with JOIN (SQL)