当先锋百科网

首页 1 2 3 4 5 6 7
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);