Update Query using another table

     Update Emp1 
     Set Emp1.sal = Emp2.sal 
     From Employee Emp1, Employee2 Emp2
     Where Emp1.empid = Emp2.empid