Update Table using Sub Query in SQL Server

Question

I want to know how to update table using sub query in SQL server. Thank you.

Jignesh Trivedi · Answer

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.

Akkiraju Ivaturi · Answer

UPDATE trips SET locations = t.city + ' ' + poi.city FROM trips t INNER JOIN ( select Distinct city trip_guid from poi ) poi ON t.trip_guid = poi.trip_guid