update department set phone = YourValue from department d inner join employee AS e ON d.deptid = e.deptid where YourCondition
UPDATE A SET A.Phoneno= 'XXXXXX' FROM Department A, Employee B WHERE A.deptId=B.deptId and B.EmpId = 'E001'
Update d Set phone = @newphoneNo From department d join Employee e on d.deptid = e.deptid where employeeid = @empid
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)