title: Concat across different tables - mysql/php stack
body: <p>I have three tables:</p>
  
  <pre><code>    Apples
  
  ID|Name
  1 |Granny
  2 |Red
  3 |Delicious
  
  Pies
  ID|Name|Apple_ID|Maker_ID
  1 |Pie |1       |1
  2 |Pie2|1       |2
  3 |Pie3|1       |3
  4 |Pie4|2       |1
  
  
  Makers
  ID|Name
  1 |Jeff
  2 |Jerry
  3 |Jeremy
  </code></pre>
  
  <p>As you can see, an apple can be in three different pies, but is connected to different makers.
  I want a query that I am preparing for export in CSV that does the following:</p>
  
  <p>I want to get one apple per row with columns for the <strong>apple ID, name and the makers names</strong> in columns, but not the "interim" link between the two tables, Pies. so like this:</p>
  
  <pre><code>Granny, Jeff, Jerry, Jeremy
  Red, Jeff
  </code></pre>
  
  <p>etc... I know I can do one query for all pies, then another for all makers, but I wonder if there was a way to concat the values from the last table as if they were in the same "row".  I also know I can just have many rows with the same values, but its preparing for somebody who wants to just look at the apple and right away know who makes a pie from it, and not scan multiple rows.</p>
  
  <p>Thanks for any help!</p>