select *

from A a, B b, B c

where a.1 =  b.1(+)

   and to_char (sysdate, 'yyyymmdd') between b.2(+) and b.3(+)

   and a.2 =  c.1(+)

   and to_char (sysdate, 'yyyymmdd') between c.2(+) and c.3(+)

--------------------------------------------------------------------------

select *

from A a, B b

where a.1 =  b.1(+)

   and to_char (sysdate, 'yyyymmdd') between b.2(+) and b.3(+)

   and a.2 =  b.1(+)

   and to_char (sysdate, 'yyyymmdd') between b.2(+) and b.3(+)

위에 sql이랑 밑에 sql의 값이 다른 던데, 

위에  sql처럼 적어주는 이유가 뭐예요...???