SQL Delete with Joins

14/3/2010

 
DELETE a FROM table1 a
INNER JOIN table2 b ON b.SomeID=a.SomeID
WHERE b.SomeField=@SomeFieldValue

Comments are closed.