title: Difference between Condition in Where and Condition in Join
body: <p>Can anyone please explain to me why the following two queries yield different results?</p>
  
  <pre><code>SELECT
      o.*
  FROM
      Customer c
  LEFT JOIN 
      [Order] o ON o.CustomerID = c.CustomerID AND o.OrderType = 'Cash'
  WHERE
      c.Country = 'USA'
  
  SELECT
      o.*
  FROM
      Customer c
  LEFT JOIN 
      [Order] o ON o.CustomerID = c.CustomerID
  WHERE
      c.Country = 'USA'
  AND
      o.OrderType = 'Cash'
  </code></pre>
  
  <p>Thanks.</p>