Update an entire single column with table joined query [duplicate]

Question

I have a table that I just added a column to and now I am trying to find an easy way to update it.

select * from KioskGoals kg inner join [TestDB].dbo.Kiosks k on kg.kioskID = k.Id

The joined table has the names I need. I want to update KioskGoals table and set the kioskName column = to the name returned from [TestDB].dbo.Kiosks which would be k.name

Is this possible with a single query?

The table that needs to be updated is KioskGoals. The column that needs to be updated is kioskName.

M.Ali · Accepted Answer · 2014-06-09 16:17:51Z

10

UPDATE kg SET Kg.kioskName = K.name from KioskGoals kg inner join [TestDB].dbo.Kiosks k on kg.kioskID = k.Id

answered Jun 9, 2014 at 16:17

M.Ali

69.9k17 gold badges110 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update an entire single column with table joined query [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related