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

You can take advantage of the "deleted" pseudo table in this example. Something like: begin transaction; declare @deletedIds table ( id int ); delete t1 output deleted.id into @deletedIds from table1 t1 join table2 t2 on t2.id = t1.id join table3 t3 on t3

stackoverflow.com