조건에 맞는 값으로 특정 Column 의 값을 UPDATE 하는 구문입니다.


UPDATE WOOJJA_CODE P
   SET WCD = (SELECT CD
                     FROM CODE_MASTER
                    WHERE SUBCD = P.SUBCD)
 WHERE EXISTS (SELECT CD
                     FROM CODE_MASTER
                WHERE SUBCD = P.SUBCD);


행복한 고수되셔요.


woojja ))*
\\\\\\\\\\\\\\\\\\\\\\\\\\
반응형

+ Recent posts