title: Which performs first WHERE clause or JOIN clause
body: <p>Which clause performs first in a <code>SELECT</code> statement?</p>
  
  <p>I have a doubt in <code>select</code> query on this basis.</p>
  
  <p>consider the below example </p>
  
  <pre><code>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
  </code></pre>
  
  <ol>
  <li><p>Whether, First it checks <code>WHERE</code> clause and then performs <code>INNER JOIN</code> </p></li>
  <li><p>First <code>JOIN</code> and then checks condition?</p></li>
  </ol>
  
  <p>If it first performs <code>JOIN</code> and then <code>WHERE</code> condition; how can it perform more where conditions for different <code>JOIN</code>s?</p>