order of join in oracle

wxdqz

New Member
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 -->
 
Back
Top