Update column with data from another column [duplicate]

Question

I'm trying to update one of my tables with data from another table. The tables have the same number of rows if that matters. However when I try to use UPDATE and SET in the below code, the column Flow in still has all null values.

UPDATE #temptableInfo
SET Flow = (SELECT xRFlow
FROM #temptableInfoPre)

Any help is appreciated.

Sample input? Table structure? What's the relationship between the 2 tables? No one can help you if we don't know these information. Read this. stackoverflow.com/help/how-to-ask — Eric
– Eric, Commented Sep 27, 2018 at 17:07

Alexey Usharovski · Accepted Answer · 2018-09-27 16:55:34Z

0

Try to use update from-from construction if your tables could by joined on some key fields

update #temptable 
set val = B.val
from #temptable A
inner join another_table B on A.id = B.link_to_a_id

answered Sep 27, 2018 at 16:55

Alexey Usharovski

1,44216 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

Update column with data from another column [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related