update delete statement with inner join in sql server

update delete statement with inner join in sql server

Now I will show you how to write update query with inner join as shown below


UPDATE E set E.EmpName='rakesh'
FROM EmployeeDetails E INNER JOIN SalaryDetails S
ON E.EmpId=S.EmpId
WHERE EmpName='Suresh'

Syntax for Delete Query with inner join will be like this

DELETE FROM table1 FROM table1 INNER JOIN table2
ON table1.columnname= table2.columnname

Example will be like this

DELETE FROM EmployeeDetails FROM EmployeeDetails E INNER JOIN SalaryDetails S
ON E.EmpId=S.EmpId
WHERE EmpName='rakesh'