I have 4 tables(a,bc,d).I am using join as mentioned below
table a inner join table b
on(condition1)
left outer join table c
on(condition2)
right outer join table d
on(condition3)
1)To my knowledge first Inner join will be performed between table a and table b.The result will be used to perform left outer join on c and then right outer join on d.Please correct me if my understanding is not correct
2)I have seen so many places where we will be using + operator instead of join keyword.I have confusion with +.Is there any way to convert this kind of query(+) to join query for easy understanding.
I am not mentioning table structure and not bother about syntax right now since this is general question which i am not aware.