Update rows from another table [duplicate]

Question

I have a table with 2 columns, Country and Qty. the field country has distinct acronyms of all the countries. Now my job is to replace those acronyms with the actual country name. Now there is another table with acronyms and corresponding country names. I have to take the values from this second table and update the first one where Acronyms match. Please help..

Quassnoi · Accepted Answer · 2011-04-15 13:19:12Z

102

UPDATE q SET country = a.country FROM quantity q JOIN acronym a ON a.acronym = q.country

answered Apr 15, 2011 at 13:19

Quassnoi

427k94 gold badges628 silver badges623 bronze badges

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

Collectives™ on Stack Overflow

Update rows from another table [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related