left outer join 썸네일형 리스트형 LEFT OUTER JOIN을 이용한 컬럼 합치기(?) SELECT * FROM(SELECT '10:00' AS DT, 'A' AS GUBUN FROM DUALUNION ALLSELECT '11:00' AS DT, 'A' AS GUBUN FROM DUALUNION ALLSELECT '14:00' AS DT, 'A' AS GUBUN FROM DUALUNION ALLSELECT '15:00' AS DT, 'A' AS GUBUN FROM DUALUNION ALLSELECT '16:00' AS DT, 'A' AS GUBUN FROM DUAL) ALEFT OUTER JOIN(SELECT 'B' AS gubun2, 'C' AS gubun3 FROM dual) BON 1=1 결과DT | GUBUN | GUBUN2 | GUBUN3 10:00ABC11:00ABC14:00AB.. 더보기 이전 1 다음