sqlerver将查询到的结果批量update某个字段

update
gas_customer_base
set
govid=b.govid
from
gas_customer_base a,
(select id,govid,customerbaseid from gas_customer )b
where
a.id=b.customerbaseid