UPDATE command in SQL server with Inner join


How can we use Update command with Inner join, if i want to update a column from different table.

I have Empid and their salary with many other information in table A but that in not correctly updated, now i have different table B with Empid and salary that is updated perfectly. If i want to update all the employees salary in table A. Can anybody help me to update table A?

Thanks in advance. 


  Devbrat Tripathi

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any