Sql Update Command
How To Update In join Condition?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Om prakash SinghPosted Jul 16, 2011, 1:37 AM
UPDATE EmployeeMaster SET LastName='Kumar'
from EmployeeMaster e,Empmasteradd a
where e.employeeid=a.emplyeeid and a.name='Hari';
Try this. If have any problem revert
Vilas GitePosted Jul 16, 2011, 1:05 AM
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"!