Update by select

update bgw_prm_alan A set (field2)=(select field1 from bgw_prm_alan B where B.id=A.id)