title: Does the order of tables referenced in the ON clause of the JOIN matter?
body: <p>Does it matter which way I order the criteria in the ON clause for a JOIN?</p>
  
  <pre><code>select a.Name, b.Status from a
  inner join b
  on a.StatusID = b.ID
  </code></pre>
  
  <p>versus</p>
  
  <pre><code>select a.Name, b.Status from a
  inner join b
  on b.ID = a.StatusID
  </code></pre>
  
  <p>Is there any impact on performance?  What if I had multiple criteria?</p>
  
  <p>Is one order more maintainable than another? </p>