Databases

SELECT된 값 바로 INSERT, UPDATE 하기

duraboys 2008. 3. 27. 19:05

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