Delete command with a join

It’s possible in SQL Server to run a delete command against a table, and join it with another.
To do this though, you need to use an alias with the table.

DELETE a
FROM Table1 a
INNER JOIN Table2 b
  ON b.Identifier = a.Identifier
WHERE b.Column1 = '1'
Subscribe

0 comments