title: What is the difference in these two queries as getting two different result set?
body: <p>I am getting different result set for these two queries and second result set seems to be correct. What is the difference in these queries.</p>
  
  <p>What type of inner join query second is?</p>
  
  <p>1) </p>
  
  <pre><code>FROM TABLE1 t1
   INNER JOIN TABLE2 t2 ON t1.Id = t2.Id
  WHERE
   t1.StatusId = 12
  </code></pre>
  
  <p>2)  </p>
  
  <pre><code>FROM TABLE1 t1
   INNER JOIN TABLE2 t2 ON t1.Id = t2.Id
   AND t1.StatusId = 12
  </code></pre>