UPDATE tb_nwmntsptrtu
SET (fd_feedwater) = (SELECT fd_gprsaddress FROM tb_nwmntspt
WHERE tb_nwmntspt.fd_seq=tb_nwmntsptrtu.fd_nwmntspotseq )
where tb_nwmntsptrtu.fd_feedwater is null
两表关联更新
最新推荐文章于 2024-07-22 15:27:09 发布
UPDATE tb_nwmntsptrtu
SET (fd_feedwater) = (SELECT fd_gprsaddress FROM tb_nwmntspt
WHERE tb_nwmntspt.fd_seq=tb_nwmntsptrtu.fd_nwmntspotseq )
where tb_nwmntsptrtu.fd_feedwater is null