Q. Delete a record with condition on multiple columns of another table.

DELETE Table1 FROM  Table1 INNER JOIN  Table2 ON  

Table1.Column1=Table2.Column1 AND Table1.Column2=Table2.Column2