2007/11/18 17:06
[놀기]
UPDATE TB_T10 T10
SET ( ORG_CD, DEPT_CD, SEQ, EMPNO, DUTY_NM ) =
( SELECT ORG_CD, DEPT_CD, SEQ, EMPNO, DUTY_NM
FROM TB_T20 T20
WHERE T10.PJ_CD = T20.PJ_CD
AND SUBSTR(PJ_CD, 5,1) != 'R');
Trackback Address :: http://dbjang.com/trackback/193
