title: FIltering on the join?
body: <p>Is there any argument, performance wise, to do filtering in the join, as opposed to the WHERE clause?</p>
  
  <p>For example,</p>
  
  <pre><code>SELECT blah FROM TableA a
  INNER JOIN TableB b
  ON b.id = a.id
  AND b.deleted = 0
  WHERE a.field = 5
  </code></pre>
  
  <p>As opposed to</p>
  
  <pre><code>SELECT blah FROM TableA a
  INNER JOIN TableB b
  ON b.id = a.id
  WHERE a.field = 5
    AND b.deleted = 0
  </code></pre>
  
  <p>I personally prefer the latter, because I feel filtering should be done in the filtering section (WHERE), but is there any performance or other reasons to do either method?</p>