Hi,
According to me ,ur query will be executed in the following order

1. a.deptid=b.deptid
2. location=3
3. b.deptid=10


In case of any help needed please ask me at [email protected]

Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
[email protected]