아래의 UPDATE 쿼리를 실행하니
에러가 뜨네요 . 무엇이 문제일까요?
UPDATE
(SELECT A.STATE_CODE, A.MODIFY_DT
FROM SAMPLE A, SAMPLE_SCHE B
WHERE A.SCHE_ID = B.SCHE_ID AND A.CREATE_DT <= DATE_FORMAT('2016081510', '%Y%m%d%H%i')
AND A.STATE_CODE IN ('W', 'R', 'N', 'P','O') AND B.TYPE='I') OA
SET OA.STATE_CODE='A', OA.MODIFY_DT=NOW() |