Which order of table joining does Oracle choose in queries?
For example there is a quiery:
table1 left join table2 inner join table3
Obviuosly, results depend on the order of joining:
Queries:
(table1 left join table2) inner join table3
and
table1 left join (table2 inner join table3)
can give different results (the first can return zero records, the second returns at least records from table1).
In real life I need to join many tables, so I should know how to interpret the results.
Thanks in advance!