title: Join three (3) MySQL tables
body: <p>unfortunately i'm not that good as SQL and i'm trying to get a join between three tables done.</p>
  
  <p>here's a rough simplified table structure:</p>
  
  <pre><code>links: id, url, description
  categories: id, name, path
  link_cat: link_id, cat_id
  </code></pre>
  
  <p>The select statement I'm aiming for should have</p>
  
  <pre><code>links.id, link.url, link.description, categories.name, categories.path
  </code></pre>
  
  <p>Where links and categories are matched via the link_cat table. I think that shouldn't be too hard as long as there's only one category for each link. This is what I'm assuming. If not it would be good to have another way that pulls multiple categories comma separated into the categories.name field. </p>
  
  <p>I hope this is all understandable and doesn't sound too silly.</p>