Join and update same column sql server [duplicate]

Question

I have 2 tables as :

TableA:

ID Value 1 A 2 B

TableB:

 Rank Value 12 A 13 B

I need to join both tables on Value column and update Value column of TableB with TableA's ID column. So result TableB will be:

Rank Value 12 1 13 2

I am using Sql Server 2008

sgeddes · Accepted Answer · 2014-05-19 20:04:18Z

2

Use update with join:

update b set b.value = a.id from tableb b join tablea a on b.value = a.value

answered May 19, 2014 at 20:04

62.9k7 gold badges67 silver badges85 bronze badges

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

Comments

Gordon Linoff · Accepted Answer · 2014-05-19 20:04:23Z

In SQL Server, you can do this with a join in the update. The specific syntax in your case is:

update b set value = a.id from tableb b join tablea a on b.value = a.value;