complexity of following join sql query [duplicate]

January 23, 2022 Off By Deanna Coleman

Which clause performs first in a SELECT statement?

I have a doubt in select query on this basis.

consider the below example

SELECT * 
FROM #temp A 
INNER JOIN #temp B ON A.id = B.id 
INNER JOIN #temp C ON B.id = C.id 
WHERE A.Name = 'Acb' AND B.Name = C.Name
  1. Whether, First it checks WHERE clause and then performs INNER JOIN
  2. First JOIN and then checks condition?

If it first performs JOIN and then WHERE condition; how can it perform more where conditions for different JOINs?