title: Having issues with a MySQL Join that needs to meet multiple conditions
body: <p>I have two tables <code>rooms</code> and <code>rooms facilities</code> and I have to select the rooms with desired facilities.</p>
  <p>If I select a room with one facility (facility with id=4 - id_fu - ). using the following query Everything it's ok:</p>
  <pre><code>SELECT u.* FROM rooms u 
  JOIN facilities_r fu 
  ON fu.id_uc = u.id_uc 
      AND fu.id_fu = '4' 
  WHERE 1 
      AND vizibility='1' 
  GROUP BY id_uc 
  ORDER BY u_premium desc, id_uc DESC 
  </code></pre>
  <p>But if I want to select the room with more facilities, let's say facilities with id=4, and id=3 ..using the following query it doesn't work:</p>
  <pre><code>SELECT u.* FROM room u 
  JOIN facilities_r fu 
  ON fu.id_uc=u.id_uc 
      AND fu.id_fu = '4' 
      AND fu.id_fu = '3' 
  WHERE 1 
      AND vizibility = '1' 
  GROUP BY id_uc 
  ORDER BY u_premium DESC, id_uc DESC 
  </code></pre>
  <p>I don't understand why it doesn't work, but I can't figure up how to put the condition.</p>