아래 쿼리로 하면 에러가 납니다. 고수님들 함봐주세요!
UPDATE T_DESM_USER
SET PSTN_ORGN =
(SELECT A.VAL1 AS PSTN_ORGN
FROM T_DESM_USER_TEMP A, T_DESM_USER B
WHERE A.USER_ID = B.USER_ID
GROUP BY
A.USER_ID, A.VAL1
)
WHERE (USER_ID) IN
(SELECT A.USER_ID AS USER_ID
FROM T_DESM_USER_TEMP A, T_DESM_USER B
WHERE A.USER_ID = B.USER_ID
GROUP BY
A.USER_ID
)
|