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