SELECT C.MOJIP_DANWI_NM 모집단위 , C.SUNBEON , C.MOJIP_JEONGWON --, MAX(DECODE(A.JEONHYEONG_GBCD,'1',FIRST_INWON,0)) AS 독자정원 --, MAX(DECODE(A.JEONHYEONG_GBCD,'2',FIRST_INWON,0)) AS 일반정원 --, MAX(DECODE(A.JEONHYEONG_GBCD,'3',FIRST_INWON,0)) AS 특별정원 , SUM(DECODE(A.JEONHYEONG_GBCD,'2',1,0)) AS 일반지원 , SUM(DECODE(A.JEONHYEONG_GBCD,'3',1,0)) AS 특별지원 , SUM(DECODE(A.JEONHYEONG_GBCD,'1',1,0)) AS 독자지원 , SUM(DECODE(A.JEONHYEONG_GBCD,'4',1,0)) AS 정원외 , SUM(DECODE(A.JEONHYEONG_GBCD,'4',1,0)) AS 전년도정원외 --빨간줄-- , TO_CHAR( SYSDATE, 'YYYY/MM/DD') AS TIME , TO_CHAR( SYSDATE, 'YYYY/MM/DD HH:MI:SS') AS TIME2 , SYS_CONTEXT('USERENV','IP_ADDRESS') AS PRINT_I FROM IP_JIWONJA_M A , IP_MOJIP_INWON_M B , IP_MOJIP_DANWI_M C WHERE A.YEAR = B.YEAR AND A.MOJIP_CD = B.MOJIP_CD AND A.JIMANG_MOJIP_DANWI_1 = B.MOJIP_DANWI AND A.JEONHYEONG_CD = B.JEONHYEONG_CD AND A.YEAR = C.YEAR AND A.JIMANG_MOJIP_DANWI_1 = C.MOJIP_DANWI AND A.YEAR = '2016' AND A.MOJIP_CD = '1' GROUP BY A.JIMANG_MOJIP_DANWI_1 , C.MOJIP_DANWI_NM , C.SUNBEON , C.MOJIP_JEONGWON ORDER BY C.SUNBEON
2016년도 입학 모집인원을 구하는 셀렉트문입니다 빨간줄에서 2016년도가 아닌 전년도
2015년도에 정원합을 구하고 싶은데 서브쿼리로 작성하려니 FROM절 오류가 자꾸나네요
어떻게 해야할까요?