t-sql update table with join
update d
set d.dname = "HR"
from Department d
inner join employee e
on e.employeeID = d.employeeID
where d.departmentID = 1
Achievement provides the only real pleasure in life
update d
set d.dname = "HR"
from Department d
inner join employee e
on e.employeeID = d.employeeID
where d.departmentID = 1
Posted by SF at 12:10 pm
No comments:
Post a Comment