UPDATE TPM10100_MCM
SET (UPCODE, SECTORCODE) = ( SELECT A.UPCODE, B.BM_CODE
FROM (SELECT JCODE,
DECODE(JONGMOK_GUBUN, '0', UPJ_S, '1', '5001') UPCODE
FROM TPM10100
) A,
(SELECT JCODE,
MIN(BM_CODE) BM_CODE
FROM TPF50410
GROUP BY JCODE
)B
WHERE A.JCODE = B.JCODE
AND A.JCODE = TPM10100_MCM.JCODE
)
WHERE JCODE LIKE '%'
|