title: Query Performance INNER JOIN ON AND comparison
body: <p>I would like to know which one is best regarding performance between the 2 queries stated below or do they perform identically?</p>
  
  <p><strong>First one: [without WHERE clause, just AND with ON]</strong></p>
  
  <pre><code>SELECT related_tabid AS tabid, label, t.name
    FROM relatedlists r
       INNER JOIN tab t 
         ON t.tabid = r.tabid
            AND t.name = 'Leads'
            AND r.is_active=1  and r.related_tabid &lt;&gt; 0
            AND t.is_active=1
    ORDER BY label
  </code></pre>
  
  <p><strong>Second one: [using WHERE clause, AND associated with where instead of ON ]</strong></p>
  
  <pre><code>SELECT related_tabid AS tabid, label, t.name
    FROM relatedlists r
       INNER JOIN tab t 
         ON t.tabid = r.tabid
         WHERE t.name = 'Leads'
               AND r.is_active=1  and r.related_tabid &lt;&gt; 0
               AND t.is_active=1
    ORDER BY label
  </code></pre>