title: What's the difference between "where" clause and "on" clause when table left join?
body: <p>SQL1:</p>
  <pre><code>select t1.f1,t2.f2 
  from t1 
     left join t2 on t1.f1 = t2.f2 and t1.f2=1 and t1.f3=0 
  </code></pre>
  <p>SQL2:</p>
  <pre><code>select t1.f1,t2.f2 
  from t1 
    left join t2 on t1.f1 = t2.f2 
  where t1.f2=1 and t1.f3=0
  </code></pre>
  <p>The difference is <code>where</code> and <code>on</code> clause, is it returning same result? and what's the difference? does DBMS run them in same way? Thanks.</p>