How do I delete from multiple tables using INNER JOIN in SQL server

In MySQL you can use the syntax. DELETE t1,t2 FROM table1 AS t1 ... You can take advantage of the "deleted" pseudo table in this example.

stackoverflow.com