outer join 썸네일형 리스트형 IINNER JOIN, LEFT OUTER JOIN, RIGHT OUTER JOIN 요즘 너무 글을 안올려서 간만에 포스팅합니다.쌩뚱맞지만 갑자기 생각나서.. 급히 짜본 쿼리;;;어려운 내용은 아니지만 기본기를 다진다는 차원에서 ^^ SELECT T1.PK AS T1_PK, T2.PK AS T2_PK, T1.COL1, T2.COL2FROM( SELECT * FROM ( SELECT '1' AS PK, 'A' AS COL1 FROM DUAL UNION ALL SELECT '2' AS PK, 'B' AS COL1 FROM DUAL UNION ALL SELECT '3' AS PK, 'C' AS COL1 FROM DUAL UNION ALL SELECT '5' AS PK, 'E' AS COL1 FROM DUAL ) ) T1 INNER JOIN -- LEFT OUTER JOIN-- RIGHT OU.. 더보기 이전 1 다음