title: Select from 3 tables with one-to-many relation
body: <p>I have a question.In my database I have 3 tables:</p>
  
  <p>Articles:</p>
  
  <pre><code>id  title  content  date
  </code></pre>
  
  <p>Tags:</p>
  
  <pre><code>id  name
  </code></pre>
  
  <p>Tags_in_news:</p>
  
  <pre><code>id  news_id  tag_id
  </code></pre>
  
  <p>Where news_id is foreign key for news table and tag_id is foreign key for tag table...How to select the articles and all tags attached to them?
  I create a query but it select a news for each tag:</p>
  
  <pre><code>SELECT * FROM articles join tags_in_news
  ON articles.id = tags_in_news.news_id
  join tags on tags.id = tags_in_news.tag_id
  ORDER BY date DESC
  </code></pre>