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
- Whether, First it checks
WHEREclause and then performsINNER JOIN - First
JOINand then checks condition?
If it first performs JOIN and then WHERE condition; how can it perform more where conditions for different JOINs?
