Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

multiple inner join ..how they work ?

user575089Aug 13 2012 — edited Aug 13 2012
Here is an example of INNER JOIN.
SELECT whatever
  FROM tablea AS a
INNER 
  JOIN tableb AS b 
    ON b.b = a.a
INNER 
  JOIN tablec AS c 
    ON c.c = b.b1
INNER 
  JOIN tabled AS d 
    ON d.d = c.c1
As you see there are 3 inner join in a single query ...I'm uncomfortable with this ....because I dont know what is the order of execution of multiple inner joins .

which inner join will be executed first and which is next and which is last ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2012
Added on Aug 13 2012
13 comments
35,562 views