PL/SQL 中我有两个表“BDC_DCB_DJ”和“XXXXXXX”,两个表中都有相同字段“ZDDM”，我想通过相同字段,把“XXXXXXX”中的“FRLXDH”关联到“BDC_DCB_DJ”中，求大神帮忙写下语句谢谢

https://www.cnblogs.com/zf29506564/p/5772095.html

select t1.*, t2.FRLXDH from BDC_DCB_DJ t1 left join XXXXXXX t2 on t1.ZDDM = t2.ZDDM;

update t1 set t1.FRLXDH = t2.FRLXDH from BDC_DCB_DJ as t1 inner join XXXXXXX as t2 on t1.ZDDM = t2.ZDDM

不是很明白楼主什么意思，你是想把“XXXXXXX”中的“FRLXDH”字段同步到“BDC_DCB_DJ”中吗？

select t1.*,t2.FRLXDH from BDC_DCB_DJ t1
left join XXXXXXX t2 on t2.ZDDM=t1.ZDDM

select a.*,b.FRLXDH from BDC_DCB_DJ a left join XXXXXXX b on a.ZDDM =b.ZDDM

这样就可以了，望采纳！给我点积分