게시일: Oct 12, 2011 11:52:1 PM
-- Cartesian Product
select a.*, b.*
from (
select '1' pid, '홍길동' pname from dual
union all
select '2' pid, '장길산' pname from dual
union all
select '3' pid, '임꺽정' pname from dual
) a -- 인간 마스터
cross join -- Cartesian Product
(
select '1' pid, '아이폰' phone from dual
union all
select '2' pid, 'HTC Desire' phone from dual
union all
select '3' pid, '갤럭시S' phone from dual
union all
select '4' pid, 'AnyCall' phone from dual
union all
select '5' pid, '휴대전화 없음' phone from dual
) b -- 인간별 소유 폰
-- where 조건 없음. ( Cartesian Product )
;
아래의 링크를 확인하시면 살아있는 코드를 확인할 수 있습니다.
↓ 혹은 여기서 바로 확인 ↓