Hi All,

I am trying to update a table. I am putting a calculated field in a temp table. and I am updating the other table with the new calculated field.

I tried this syntax:

update table A
set A.col=B.col
from B(temp table)
where A.colA=B.colA

but I am having an error.


Thank you for your help in advance.

try this:

update table A
set A.col = (select B.col
from table B
where A.colA=B.colA)