title: WHERE with joined tables
body: <p>I basicly have a query similiar to this:</p>
  
  <pre><code>SELECT * FROM news
  LEFT JOIN tags ON tags.newsid = news.id
  </code></pre>
  
  <p>Now let's say, that I want to get all <code>news</code> rows which have a tag (row in <code>tags</code> table) that's <code>tags.name</code> value is "test" and another tag that's <code>tags.name</code> value is "test2". 
  So basicly, I would like to check for two values in a joined table, if they are both in there, then give back that <code>news</code> row.</p>
  
  <p>How would this be possible? Sorry if this has been asked before, I don't really know what kind of keywords I would use in my search for this particular question, since it's quite complicated.</p>