Have a Question?

If you have any question you can ask below or enter what you are looking for!



UPDATE command in SQL server with Inner join

Hi,

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