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 ?