title: SQL query for multiple tag inclusion
body: <p>I´m net very good in explaining this. But i do my best:</p>
  
  <p>I've made a tagging tool for people. Some people contains more then 1 tag, and i need to get those but dont know how to write the SQL query for multiple tag inclusion.</p>
  
  <p>I know you can't write WHERE conditions like this:<br>
  LOWER( peoples_tags.tag_id ) = 'outside' AND<br>
  LOWER( peoples_tags.tag_id ) = 'summer'</p>
  
  <p>Cause each person result is on his own row and 'outside' and 'summer' wont be on the same row. So you don't get any results by using this query.</p>
  
  <p>This is the whole query:<br>
  SELECT DISTINCT peoples.*,tags.tag FROM people<br>
  JOIN peoples_tags ON peoples_tags.people_id = peoples.id<br>
  JOIN tags ON tags.tag = peoples_tags.tag_id AND<br>
  LOWER( peoples_tags.tag_id ) = 'outside' AND<br>
  LOWER( peoples_tags.tag_id ) = 'summer'</p>
  
  <p>So how do i write a multiple tag SQL condition? Someone knows?<br>
  Sorry for my bad english :)</p>