question

shivamk21 avatar image
shivamk21 asked

I want to update a column of a table with some string and another column using join with the help of procedure.

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);

sqlsql server
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.