SELECT ROWNUM
, A.CONTENTS_ID
, A.TITLE
, A.DESCRIPTION
, A.LANG_CD
, A.UPDATE_DATE
FROM (
SELECT B.CONTENTS_ID
, B.TITLE
, B.DESCRIPTION
, B.LANG_CD
, B.UPDATE_DATE
FROM TB_CONTENTS B
WHERE 1=1
AND B.CONTENTS_TYPE = 'FOT'
AND B.USE_YN = 'Y'
AND B.DEL_YN = 'N'
AND B.POC_CD = 'NO'
AND B.LANG_CD = 'KO'
ORDER BY B.UPDATE_DATE ASC
) A
ORDER BY ROWNUM DESC
;
SELECT COMP_TYPE
, COMP_TEXT
FROM TB_CONT_COMPONENT
WHERE 1=1
AND COMP_TYPE = 'A3'
AND LANG_CD = 'KO'
AND ROWNUM = 1
ORDER BY SORT_NO ASC
;
위 두개의 쿼리를 하나로 합치려고 합니다
그래서 제가 아래 처럼 해봤는데
SELECT ROWNUM
, A.CONTENTS_ID
, A.TITLE
, A.DESCRIPTION
, A.LANG_CD
, A.UPDATE_DATE
, A.COMP_TYPE
, A.COMP_TEXT
FROM (
SELECT B.CONTENTS_ID
, B.TITLE
, B.DESCRIPTION
, B.LANG_CD
, B.UPDATE_DATE
FROM (
SELECT C.COMP_TYPE
, C.COMP_TEXT
FROM TB_CONT_COMPONENT C
WHERE 1=1
AND C.COMP_TYPE = 'A3'
AND C.LANG_CD = 'KO'
AND ROWNUM = 1
ORDER BY C.SORT_NO ASC
) B
WHERE 1=1
AND B.CONTENTS_TYPE = 'FOT'
AND B.USE_YN = 'Y'
AND B.DEL_YN = 'N'
AND B.POC_CD = 'NO'
AND B.LANG_CD = 'KO'
ORDER BY B.UPDATE_DATE ASC
) A
ORDER BY ROWNUM DESC
;
잘 안되네요...이렇게 저렇게 만져봤는데...오류만 계속 나오네요...
혹시 제가 어느 부분을 잘못 작성했는지 알수있을까요...