SQL delete with join

This statement deletes data from Table1. This is useful if you have a join with multiple tables or multiple columns.
FROM Table1 t1 JOIN Table2 t2 
ON t1.Id1 = t2.Id1
AND t1.Id2 = t2.Id2


Popular posts from this blog

Parse XML to dynamic object in C#

Parse XML to object model in C# using XSD utility