title: SQLite not getting double data
body: <p>I have rating system which people can rate on ideas. The user can get a summary from the SQLite database of ideas he hasn't voted for yet. My problem is that the database still gets the ideas he already voted for. My Table where the query has to operate looks like this:</p>
  
  <pre><code>ID (pk), ratingScore, userID, ideaID  
  1         3           1       1
  2         4           2       1
  3         5           2       2
  </code></pre>
  
  <p>Ratings score is the score the user has given the idea, userID is the ID of the user who voted and ideaID is the ID of the idea.</p>
  
  <p>How can I get the ideas from user 1 where he hasn't voted for without getting the other ideas, so the result of the query on this table would have been only 'ideaID 2'. </p>
  
  <pre><code>SELECT Ratings.ideaID
  FROM Ratings
  WHERE (NOT(Ratings.userID)=1)
  GROUP BY ideaID;
  </code></pre>
  
  <p>This is what I tried, but it didn't work, I also tried DISTINCT but that doesn't work either.</p>