update (
SELECT a.sqdxh a1, b.dmbh a2 ,b.dmmc a3 ,c.ydlb a4
FROM JF_YDSQD a,dmb b ,bzjd_ydhqd c
where a.ydlb = b.dmbh and b.dmlbbh_id ='03'
and a.sqdxh = c.ydsqdxh
)
set a4=a3
SELECT a.sqdxh a1, b.dmbh a2 ,b.dmmc a3 ,c.ydlb a4
FROM JF_YDSQD a,dmb b ,bzjd_ydhqd c
where a.ydlb = b.dmbh and b.dmlbbh_id ='03'
and a.sqdxh = c.ydsqdxh
)
set a4=a3
update bzjd_ydhqd
set ydlb =
(SELECT b.dmmc
FROM JF_YDSQD a,dmb b
where a.ydlb = b.dmbh and b.dmlbbh_id ='03'
and a.sqdxh = bzjd_ydhqd.ydsqdxh );
set ydlb =
(SELECT b.dmmc
FROM JF_YDSQD a,dmb b
where a.ydlb = b.dmbh and b.dmlbbh_id ='03'
and a.sqdxh = bzjd_ydhqd.ydsqdxh );
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/21107134/viewspace-1018764/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
ORACLE体系结构之集群(RAC)
下一篇：
没有了~
请登录后发表评论
登录
全部评论
