title: SQL: selecting things ONLY associated with one value
body: <p>Ok so i'm trying to write a query that returns duplicate values ONLY if they are in the same column and associated with one particular value. </p>
  
  <p>So say for example there are 5 apples in a database, but 1 of them is associated as 'red' whilst the other are 'green', none of the apples would be returned in a query selecting fruits with only one association. However if there were 4 apples in another database and all of them were only associated with 'red', then all of them would be returned in a query selecting fruits with only one association. Assuming there are only 2 different values, red and green.</p>
  
  <p>So my query would look like this:</p>
  
  <pre><code>SELECT Apples
  FROM Fruits
  WHERE Colour = 'RED' AND Colour NOT IN (SELECT Apples FROM Fruits WHERE Colour =    'GREEN')
  </code></pre>
  
  <p>My query doesnt run or return the results i need, how do i return values only associated with a single value?</p>
  
  <p>Can anyone help out?</p>
  
  <p>EDIT: okay i didnt use an effective analogy, i'm only trying to get values that are associated with only one value. Check my comment to see the better analogy i used</p>