I want to update a column of a table with some string and another column using join with the help of procedure. I tried something like below but its not working, UPDATE [dbo].[JETSTAR_DEALS] SET Culture='SG',OriginStateCode = STATE_CODE FROM [dbo].[JETSTAR_DEALS] INNER JOIN [dbo].[STATES] ON ([OriginAirportCode] = AIRPORT_CODE);