title: T-SQL: Additional predicates on JOINs vs. the WHERE clause
body: <p>Is there any difference between putting additional predicates on a JOIN statement vs. adding them as additional clauses in the WHERE statement?</p>
  
  <p><strong>Example 1: Predicate on the WHERE clause</strong>  </p>
  
  <pre><code>select emp.*
  from Employee emp
  left join Order o on emp.Id = o.EmployeeId
  where o.Cancelled = 0
  </code></pre>
  
  <p><strong>Example 2: Predicate on the JOIN statement</strong>  </p>
  
  <pre><code>select emp.*
  from Employee emp
  left join Order o on emp.Id = o.EmployeeId and o.Cancelled = 0
  </code></pre>