SELECT 된문 UPDATE 하기
UPDATE A
SET A.ATTEND_rsn1 = '1'
FROM LMS_ATTEND A, LMS_USER_PARTY B
WHERE A.YEAR_CD = '2008'
AND A.MONTH_CD = '2'
AND A.STUDENT_ID = B.USER_ID
AND A.PARTY_SEQ = B.PARTY_SEQ
AND B.FLAG = 'A'
AND A.STUDENT_ID IN( SELECT USER_ID
FROM LMS_USER
WHERE ACADEMY_CD = '10003'
AND DEL_YN <> 'Y' )
---------------------------------------------------------------------------
SELECT 된문 INSERT 하기
INSERT INTO EMPS( EMPNO, ENAME, SAL , DEPTNO)
SELECT EMPNO, ENAME, SAL , DEPTNO
FROM EMP
WHERE DEPTNO=10
[출처] SELECT된 값 바로 INSERT, UPDATE 하기|작성자 초록공룡
이올린에 북마크하기모든 포스팅글 하단에 한줄광고를 넣을수있습니다 / 문의 : duraboys@gmail.com
