How can I control the order of joins in oracle?
I want to execute the following query:
select *
from
a inner join b left join c
when i write:
select *
from a , b , c
where a = b
and b(+) = c
i don't get any rows when b inner join c is null.
(I don't want to use view or function or inner select)
thanks,
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->
I want to execute the following query:
select *
from
a inner join b left join c
when i write:
select *
from a , b , c
where a = b
and b(+) = c
i don't get any rows when b inner join c is null.
(I don't want to use view or function or inner select)
thanks,
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->