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
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