title: SQL - Find patient that has all availabe diseases
body: <p>I have the following tables</p>
  
  <p>Patient</p>
  
  <pre><code>pID &lt;&lt;PK&gt;&gt;
  
  pName
  </code></pre>
  
  <hr>
  
  <p>DiseaseList</p>
  
  <pre><code>dName &lt;&lt;PK&gt;&gt;
  </code></pre>
  
  <hr>
  
  <p>SuffersFrom (dName and pID are also PK for SuffersFrom)</p>
  
  <pre><code>dName &lt;&lt;FK&gt;&gt; 
  
  pID &lt;&lt;FK&gt;&gt;
  </code></pre>
  
  <hr>
  
  <p><strong>What I want to do is SELECT the name of the the Patient that suffers from all the diseases in DiseaseList</strong> but I really don't know how I'd do this. </p>
  
  <p>I have tried searching the web but didn't find anything that helped me. This is the only task I have left to do for a SQL introduction class and I really cannot think of how to set up the query.</p>