title: Select in MySQL based on two tables
body: <p>I have two tables.</p>
  
  <p>diseases</p>
  
  <pre><code>-----------------------------
  | ID  |  NAME               |
  -----------------------------
  | 1   | Disease 1           |
  | 2   | Disease 2           |
  | 3   | Disease 3           |
  </code></pre>
  
  <p>diseases_symptoms</p>
  
  <pre><code>-----------------------------
  | DISEASE_ID  | SYMPTOM_ID  |
  -----------------------------
  | 1           | 1           |
  | 1           | 2           |
  | 1           | 3           |
  | 1           | 4           |
  | 2           | 1           |
  | 2           | 2           |
  </code></pre>
  
  <p>I want to select all diseses which have symptoms 1 or 2 and 3 or 4.</p>
  
  <p>I've tried:</p>
  
  <pre><code>SELECT * 
   FROM diseases_symtoms 
  WHERE (symptoms = '1' OR symptoms = '2') 
    AND (symptoms = '3' OR symptoms = '4')
  </code></pre>
  
  <p>And:</p>
  
  <pre><code>SELECT * 
    FROM diseases_symtoms 
    WHERE symptoms IN ('1','2') 
      AND symptoms IN ('3','4')
  </code></pre>
  
  <p>...but it is not working.</p>