UPDATE 要更新的表
SET 字段1 = cqt.字段1,
字段2 = cqt.字段2,
FROM
数据来源表 cqt
WHERE
要更新的表.bsm = cqt.bsm
例:
根据 2张表id_isin 一样, 去 更新 orbit_instrument_extend 表 的 id_mic_prim_exch列
update orbit_instrument_extend
set id_mic_prim_exch =cqt.id_mic_prim_exch
from orbit_primary_instrument cqt
where orbit_instrument_extend.isin= cqt.id_isin