title: WHERE and WHERE NOT in SELECT
body: <p>How would I use a WHERE and WHERE NOT in the same SELECT SQL query?</p>
  
  <p>For example, I could have a table called fruits.</p>
  
  <pre><code>ID | Name       | Colour
  -------------------------
  1  | Strawberry | Red 
  2  | Apple      | Red
  3  | Grape      | Red
  4  | Banana     | Yellow
  </code></pre>
  
  <p>From this table, I could execute a <code>SELECT * FROM [fruits] WHERE Colour = 'Red'</code>, and it would retrieve the following: </p>
  
  <pre><code>ID | Name       | Colour
  -------------------------
  1  | Strawberry | Red 
  2  | Apple      | Red
  3  | Grape      | Red
  </code></pre>
  
  <p>However, I would like to exclude <code>Apple</code> from the single request above, I could use a <code>WHERE NOT</code>, but this would return all fruits, including <code>Banana</code>.</p>
  
  <p>How would I write an SQL query so that it would result in the following, a specific colour being chosen, but excluding a specific fruit:</p>
  
  <pre><code>ID | Name       | Colour
  -------------------------
  1  | Strawberry | Red 
  3  | Grape      | Red
  </code></pre>
  
  <p>I am using MsSQL 2014, any help would be appreciated.</p>