sql transform list another formed id match


i have database account numbers card numbers. i review record update any tag numbers comment number, i am wholly operative comment numbers.



i combined perspective fasten list account/card database relapse table id associated comment number, i need transform those annals where id matches comment number.



this sales_import table, where account number domain needs updated:



leadid  accountnumber
147 5807811235
150 5807811326
185 7006100100007267039


and retrieveaccountnumber table, where i need transform from:



leadid  accountnumber
147 7006100100007266957
150 7006100100007267039


i attempted below, nonetheless fitness far:



update [sales_lead].[dbo].[sales_import] 
set [accountnumber] = (select retrieveaccountnumber.accountnumber
retrieveaccountnumber
where [sales_lead].[dbo].[sales_import]. leadid =
retrieveaccountnumber.leadid)


it updates tag numbers comment numbers, nonetheless comment numbers gets transposed null



Comments

Popular posts from this blog

list macos calm editors formula editors

how hibernate @any-related annotations?

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?