Oracle update ....select

update jwpz_zidianzy a  set leibiedm=(select leibiedm from jwpz_zidianlb where jwpz_zidianlb.id=a.zidianlb )