title: SQL Different between Left join on... and Left Join on..where
body: <p>I have two sql to join two table together:</p>
  
  <pre><code>select top 100 a.XXX
                ,a.YYY
                ,a.ZZZ
                ,b.GGG
                ,b.JJJ
  from table_01 a 
      left join table_02 b
          on a.XXX = b.GGG
              and b.JJJ = "abc"
              and a.YYY between '01/08/2009 13:18:00' and '12/08/2009 13:18:00'
  </code></pre>
  
  <hr>
  
  <pre><code>select top 100 a.XXX
                ,a.YYY
                ,a.ZZZ
                ,b.GGG
                ,b.JJJ 
  from table_01 a 
      left join table_02 b
          on a.XXX = b.GGG 
  where b.JJJ = "abc"
      and a.YYY between '01/08/2009 13:18:00' and '12/08/2009 13:18:00'
  </code></pre>
  
  <p>The outcome of them is different but I don't understand the reason why.<br>
  I would be grateful if I can get some help here.</p>