Update Table using Sub Query in SQL Server

hi,

you can also acheive this by using inner join

update CustomerMaster
set CustomerMaster.Code = z.Code + 'AA'
from CustomerMaster z
inner join TEMP_DimCustomer b
on z.Key=b.Key

hope this will help you.