title: SQL Join query with filter condition : performance
body: <p>I want to join a couple of tables but filter a particular type from 'A' table. Which is the better query from the following two queries (is there a better approach?) or is there no difference cause of query optimizer ?</p>
  
  <p>When filter condition is given in 'WHERE' clause:</p>
  
  <pre><code>SELECT .. FROM A a JOIN B b ON a.id=b.id JOIN C c on a.id = c.id...&lt;other joins&gt;...WHERE a.col='SOME_VAL';
  </code></pre>
  
  <p>The filter condition is given inside 'ON':</p>
  
  <pre><code>SELECT .. FROM A a JOIN B b ON a.id=b.id AND a.col='SOME_VAL' JOIN C c on a.id = c.id...&lt;other joins&gt;
  </code></pre>