title: SQL Query - INNER JOIN - WHERE vs AND
body: <p>I was practising SQL queries and my solution to a question was:</p>
  
  <pre><code>SELECT C.*
  FROM customer C
  INNER JOIN salesman S ON C.salesman_id = S.salesman_id
    AND S.commission &gt; 0.12
    AND S.city &lt;&gt; C.city;
  </code></pre>
  
  <p>And the solution given to this question was:</p>
  
  <pre><code>SELECT C.* 
  FROM customer C  
  INNER JOIN salesman S  ON C.salesman_id = S.salesman_id 
  WHERE S.commission &gt; .12 
    AND C.city &lt;&gt; S.city;
  </code></pre>
  
  <p>However there is no difference between the two outputs. </p>
  
  <p>So I wanted to understand when should I use <code>WHERE</code> clause and <code>AND</code>clause with <code>INNER JOIN</code> ? </p>
  
  <p>Will there be any performance differences between the two given queries?</p>