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.