title: SQL 'WHERE' versus 'ON' (inner join)
body: <p>When doing an SQL query,</p>
  
  <p>is there any significant (or any at all) difference in performance between 'WHERE' and 'ON'?</p>
  
  <p>I know there is a significant difference in the resulting set between the two for a LEFT or RIGHT JOIN.</p>
  
  <p>What about an INNER JOIN?</p>
  
  <p>Is there any drawback to using 'ON' for each of my selects rather than 'WHERE' at the end?</p>