Update SQL from a joined table

[hermantb]

I am trying to make sure account names in two tables are the same, but this update query is failing. What am I doing wrong?

update s set s.account = a.account
from account a inner join accountsummary s on a.accountid = s.accountid

Thanks,
TBH

 

[TitleistDBA]

try this

update s
set s.account = a.account
from s, a
where s.id = a.id

http://www.acushnetcompany.com

 

[iker3000]

It should be more efficient and clear, if you use a join?

UPDATE s
SET account = a.account
FROM
s
INNER JOIN a
ON a.ID = s.ID

Iker