Thursday, March 13, 2008

T-SQL

There are two employee tables named emp1 and emp2. Both contains same structure (salary details). But Emp2 salary details are incorrect and emp1 salary details are correct. So, write a query which corrects salary details of the table emp2

update a set a.sal=b.sal from emp1 a, emp2 b where a.empid=b.empid

No comments: