쿼리 출처 : 오라클닷컴
--------------------------------------------------------------------------------------------------------------------
WITH t AS (
SELECT '01-1-001' 접수번호, '1' 구분, '11' 제출서류코드 FROM IQ_DUMMY
UNION ALL SELECT '01-1-001', '1', '12' FROM IQ_DUMMY
UNION ALL SELECT '01-1-001', '1', '14' FROM IQ_DUMMY
)
SELECT t.제출서류코드
,CASE WHEN t.제출서류코드 <> ' ' THEN 'Y'
ELSE 'N'
END AS code
FROM t, ( SELECT '11' 제출서류코드 FROM IQ_DUMMY
UNION ALL SELECT '12' FROM IQ_DUMMY
UNION ALL SELECT '13' FROM IQ_DUMMY
UNION ALL SELECT '14' FROM IQ_DUMMY
) t1
WHERE t.제출서류코드(+) = t1.제출서류코드;
--------------------------------------------------------------------------------------------------------------------
돌려보면 실행이 안되는데, Sybase에서도 with 구문이 먹히나요? |