DB2 UPDATE using a subquery - Experts Exchange - The network for technology professionals.

DB2 UPDATE using a subquery - Experts Exchange - The network for technology professionals.

瀏覽:1008
日期:2026-04-24
UPDATE CPDB01.CPEUIT_ENROLL_USER U2 SET U2.MKT_KEY = (SELECT M.MKT_KEY FROM CPDB01.CPLUIT_LDAP_USERS L INNER JOIN CPDB01.CPMCIT_MKT_CO_LIST M ON L.MKT_CD = M.MKT_CD WHERE U2.ACTIVE_FLAG = '1' AND LCASE ......看更多