WITH t (상품명, 색상, 사이즈, 구분, 박스수, 박스당수량, 총수량) AS
(
SELECT '상품1', '노랑', 'S', '백화점', 1, 50, 50 FROM dual
UNION ALL SELECT '상품1', '노랑', 'S', '아울렛', 2, 51, 102 FROM dual
UNION ALL SELECT '상품1', '노랑', 'M', '백화점', 3, 51, 153 FROM dual
UNION ALL SELECT '상품1', '노랑', 'M', '아울렛', 4, 51, 204 FROM dual
UNION ALL SELECT '상품2', '빨강', 'S', '백화점', 5, 51, 255 FROM dual
UNION ALL SELECT '상품2', '빨강', 'S', '백화점', 6, 51, 306 FROM dual
UNION ALL SELECT '상품2', '빨강', 'M', '백화점', 7, 51, 357 FROM dual
UNION ALL SELECT '상품2', '빨강', 'M', '백화점', 8, 51, 408 FROM dual
)
WITH t1 (점포, 구분) AS
(
SELECT '롯데', '백화점' FROM dual
UNION ALL SELECT '현대', '아울렛' FROM dual
)
SELECT t.색상, t1.점포, t1.구분
FROM t
left join t1
on t.구분 = t1.구분
;
에러남