INSERT INTO PER_BSE_INF (LGLPSN_ENT_CD,CUST_NO) SELECT NEW_BANK_ID,NEW_CUST_NO FROM OLD_NEW_CSTNO
WHERE not exists (select * from PER_BSE_INF where PER_BSE_INF.CUST_NO = OLD_NEW_CSTNO.NEW_CUST_NO);
从a表插入b表没有的数据
最新推荐文章于 2023-06-06 08:49:38 发布
INSERT INTO PER_BSE_INF (LGLPSN_ENT_CD,CUST_NO) SELECT NEW_BANK_ID,NEW_CUST_NO FROM OLD_NEW_CSTNO
WHERE not exists (select * from PER_BSE_INF where PER_BSE_INF.CUST_NO = OLD_NEW_CSTNO.NEW_CUST_NO);