Thursday, March 10, 2016

Syntax for Delete with Inner join

Incase you need to delete from One table using a reference values from another table referenced values and Not foreign keys. You can use the following syntax

Delete Emp from  Employee Emp
Inner Join @TmpTable TT on TT.DeptId=Emp.DeptId

1 comment :

narayana p said...

It was so nice article. I was really satisfied by seeing this article. SQL server dba Online Training Bangalore