Infra/DataBase
[SQL] 다중업데이트
감마
2009. 10. 9. 16:38
UPDATE PRODUCT_INF a
SET ( a.apply_dt, a.conf_dt) = (SELECT CREATIONDATE,
CREATIONDATE
FROM KTCMASTER01T b
WHERE a.product_id= b.clubid
)
WHERE EXISTS
(SELECT 'x'
FROM KTCMASTER01T b
WHERE a.product_id= b.clubid AND b.USEYN='Y' )