Sql Update Command

Question

How To Update In join Condition?

Om prakash Singh · Answer

use the query like this UPDATE EmployeeMaster SET LastName= 'Kumar ' from EmployeeMaster eEmpmasteradd a where e.employeeid=a.emplyeeid and a.name='Hari' ; Try this. If have any problem revert

Vilas Gite · Answer

Welcome Rajesh in Our Community! Please see in details http://msdn.microsoft.com/en-us/library/8hwekas8(v=vs.80).aspx --------------------------------------------------------------------------------------------------- If this reply hepls your post…then  MARK AS ANSWER !