title: How to solve this specific SQL query?
body: <p>I am stuck with an this SQL problem: I need to find all members who did not pay their annual fees for 2014. Here is a sample of the database:</p>
  
  <pre><code>Table 'members'
  
  | ID | name   |
  ---------------
  | 1  | Franck | 
  | 2  | Andy   |
  | 3  | Jack   |
  
  
  Table 'payements'
  
  | ID  | memberID | year   | amount |
  ------------------------------------
  | 1   | 1        | 2013   | 100    |
  | 2   | 1        | 2014   | 100    |
  | 3   | 2        | 2013   | 100    |
  </code></pre>
  
  <p>And I tried something like this:</p>
  
  <pre><code>SELECT members.name FROM members
  LEFT JOIN payements ON (payements.memberID = members.ID)
  WHERE (payements.year = 2014 AND payements.amount &lt; 100) OR payements.memberID IS NULL
  </code></pre>
  
  <p>My query correctly finds Jack (who did never pay anything) but fails to find Andy because an entry exists for another year. How can I ask for all members who have no entry specifically for 2014 (or an entry with an amount below 100)?</p>