with t as(
select '1' col from dual union all
select '2' col from dual union all
select '12' col from dual union all
select '123' col from dual union all
select '23' col from dual
),
s as
(
select '1' col ,'855' emp from dual union all
select '2' col ,'866' emp from dual union all
select '12' col , '877' emp from dual
),
a as
(
select '855' emp ,123 money from dual union all
select '866' emp ,1234 money from dual union all
select '877' emp ,12345 money from dual
)
select t.col,a.money
from s inner join a
on s.emp = a.emp
right outer join t
on t.col = s.col
select t.col,nvl(a.money,0)
from (
select s.col,a.money
from s,a
where s.emp = a.emp
) a , t
where t.col = a.col(+)
두개의 쿼리를 돌리면 값은 동일하게 나오는데요 위에 안시조인을 사용한 쿼리문을 밑에 있는 쿼리문과 동일하게 돌아간다고 봐도 될까요???
s inner join a
on s.emp = a.emp
이부분이 서브쿼리처럼 돌고
right outer join t
이 이루어지는건지요??