Waht is the order of select query execution in nested select statement

[avinashd_m]

Hi All,

I have select query like below :

where i have join and nested select statement, here can anyone please let me know, what is the order of execution of select statements(normal and sub/nested query), will the nested query executes first before execution of join?

Is there any way to determine the order of execution here ?

[matt]

Run the program while SQL trace is on (ST05). Then you can look at the execution path.