title: MySQL Join many to many
body: <p>I have three tables:</p>
  <p>producer:
  <a href="https://i.stack.imgur.com/sfzQe.png" rel="nofollow noreferrer">Producer</a></p>
  <p>series_producer:
  <a href="https://i.stack.imgur.com/qSca8.png" rel="nofollow noreferrer">series_producer</a></p>
  <p>and series:
  <a href="https://i.stack.imgur.com/ZG8CW.png" rel="nofollow noreferrer">series</a></p>
  <p>What i am trying to do is to do a select on producers and also show the names of the series they have created.
  ex.</p>
  <pre><code>producer_id    producer_name    producer_series
  1              Marta Kauffman   Friends, Dream On
  </code></pre>
  <p>I am able to show it with the id of the series, but i want the name instead..</p>
  <p>This is my SQL to do that:</p>
  <pre><code>-- View all series from one producer
  select producer_id, producer_name, group_concat(series_producer_sid) as prods
  from producer w join
       series_producer uw
       on producer_id = uw.series_producer_pid
  group by producer_id;
  </code></pre>
  <p>How can i do it?</p>
  <p>Thanks in advance!</p>