title: SQL - can we combine AND operator and NOT IN?
body: <p>can we combine the AND operator and NOT IN in mysql? for example:</p>
  
  <pre><code>WHERE x AND y NOT IN ( SELECT X,Y
                     FROM ....
  
                    );
  </code></pre>
  
  <p>Is the syntax correct?</p>