title: MySQL Join clause vs WHERE clause
body: <p>What's the difference in a clause done the two following ways?</p>
  
  <pre><code>SELECT * FROM table1 INNER JOIN table2 ON (
      table2.col1 = table1.col2 AND
      table2.member_id = 4
  )
  </code></pre>
  
  <p>I've compared them both with basic queries and <code>EXPLAIN EXTENDED</code> and don't see a difference.  I'm wondering if someone here has discovered a difference in a more complex/processing intensive envornment.</p>
  
  <pre><code>SELECT * FROM table1 INNER JOIN table2 ON (
      table2.col1 = table1.col2
  )
  WHERE table2.member_id = 4
  </code></pre>