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

FROM #temp A 
INNER JOIN #temp B ON = 
INNER JOIN #temp C ON = 
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?