title: Query that returns values where a certain number of rows meet certain condition
body: <p>I'm trying to make a report and i'm having some dificulty designing a query to show the data i need.</p>
  
  <p>I have 2 tables:</p>
  
  <pre><code>+-----------+------------+----------+
  +TherapyID  + CostumerID + ClinicID +
  +-----------+------------+----------+
  +    1      +  John      + Clinic 1 +
  +-----------+------------+----------+
  +    2      +  Susan     + Clinic 2 +
  +-----------+------------+----------+
  +    3      +  Mary      + Clinic 3 +
  +-----------+------------+----------+
  
  
  +-----------+--------------+-----------+--------+
  +TherapyID  + TherapyLine  + Treatment + Result +
  +-----------+--------------+-----------+--------+
  +     1     +       1      +     A     + Success+
  +-----------+--------------+-----------+--------+
  +     1     +       2      +     B     + Success+
  +-----------+--------------+-----------+--------+
  +     1     +       3      +     C     + Success+
  +-----------+--------------+-----------+--------+
  +     2     +       1      +     A     + Success+
  +-----------+--------------+-----------+--------+
  +     2     +       2      +     B     + Fail   +
  +-----------+--------------+-----------+--------+
  +     2     +       3      +     C     + Success+
  +-----------+--------------+-----------+--------+
  +     3     +       1      +     A     + Success+
  +-----------+--------------+-----------+--------+
  +     3     +       2      +     B     + Success+
  +-----------+--------------+-----------+--------+
  +     3     +       3      +     C     + Fail   +
  +-----------+--------------+-----------+--------+
  </code></pre>
  
  <p>I need to make a query that shows me only the customers or therapyid's that have successfully received all treatments <strong>A,B,C</strong></p>
  
  <p>The Query Result should be like this:</p>
  
  <pre><code>+------------+-------------+----------+---------+-----------+---------+
  + TherapyID  + TherapyLine + Customer +  Clinic + Treatment + Result  +
  +------------+-------------+----------+---------+-----------+---------+
  +     1      +     1       +  John    + Clinic 1+    A      + Success + 
  +------------+-------------+----------+---------+-----------+---------+
  +     1      +     2       +  John    + Clinic 1+    B      + Success +
  +------------+-------------+----------+---------+-----------+---------+
  +     1      +     3       +  John    + Clinic 1+    C      + Success +
  +------------+-------------+----------+---------+-----------+---------+
  </code></pre>
  
  <p>This was the only therapyid where all treatments <strong>A,B,C</strong> where <strong>Success</strong>
  I really don't have any idea on how to query this, what i have tried up to now
  allways returns results from <strong>TherapyID</strong> *<em>2,3</em>* where result was <strong>Success</strong> too.
  Thx in advance for the help.</p>