UPDATE AMC_FAX_ADDRESS_LIST AFAL
SET (FAX1, FAX2, TEL1, TEL2) =
(SELECT BFI.LXR_FAX, BFI.JBR_FAX, BFI.LXR_TEL, BFI.JBR_TEL
FROM BASE_FAXLIST_INFO BFI
WHERE BFI.FAXID = AFAL.UUID)
WHERE EXISTS
(SELECT 1 FROM BASE_FAXLIST_INFO BFI WHERE BFI.FAXID = AFAL.UUID);
Oracle两表之间数据更新
最新推荐文章于 2024-04-19 20:58:15 发布