title: SQL LEFT JOIN for joining three tables but one with to exclude content
body: <p>I have 3 tables</p>
  
  <ul>
  <li>STUDENTS</li>
  <li>FEES_PAID</li>
  <li>SUSPENDED</li>
  </ul>
  
  <p>I want to get the details of the students who have paid the fees but not from <code>SUSPENDED</code>.</p>
  
  <pre><code>SELECT
      ID
  FROM
      STUDENTS s
  LEFT JOIN
      SUSPENDED p ON s.ID = p.ID
  INNER JOIN 
      FEES_PAID f ON f.ID = s.ID
  WHERE
      s.ID IS NULL
  </code></pre>
  
  <p>Unfortunately this does not work. Can any one suggest an efficient query?</p>
  
  <p>Thanks in advance</p>