>>367,370
試してないけどこれでどう?
update AAA
from AAA,(select 式 as B1) as BBB
set 数値 = BBB.B1