Follow by Email

Monday, July 22, 2013

update table using from clause in a database | using from clause updating table records query example

Below is the query using from clause to update table records :

update Employee 
set Deptname = cc.Deptname
FROM Employee dd
inner join Department cc on  cc.DeptId = dd.DeptId
where dd.salary is not null