Update Query with Inner join in SQL Server

Suppose, If you want update a table based on some other references from other table. In that case, you can go for the below query to update the table.

update z

set z.YearlyIncome = b.YearlyIncome
from DimCustomer z inner join TEMP_DimCustomer b
on z.CustomerKey=b.CustomerKey

Cheers,
Venkatesan Prabu .J
Ebook Download
View all
Learn
View all