Update Query With Multiple Table

Jayakumars
Posted by Jayakumars under Sql Server category on | Points: 40 | Views : 846
Hi
I have post the Code

-- Update Query With Multiple Table
UPDATE Table_3 SET Salary =Salary+500 WHERE Salary>500 AND Emp_id=
(SELECT Empid from Table_3 t1,Table_4 t2 WHERE t1.Emp_Id=t2.EmpId AND Drpt='IT')

Comments or Responses

Login to post response