title: MySQL Left Join Many to One Row
body: <p>To simplify my problem: Let's say I have 3 tables.</p>
  
  <pre><code>Rooms              People                    Things
  --------           --------                  --------
  id| name           id | name | fk_rooms      id | name | fk_rooms
  -----------        ---------------------     ---------------------
  1 | kitchen        1  | John | 1              1 | TV   | 2
  2 | bedroom        2  | Mary | 2              2 | bed  | 2
                     3  | Andy | 1              3 | sink | 1
                     4  | Laura| 1
  </code></pre>
  
  <p>Now I'm doing something like:</p>
  
  <pre><code>SELECT r.name AS room_name, p.name AS name, t.name AS thing FROM Rooms r 
  LEFT JOIN People p ON p.fk_rooms = r.id
  LEFT JOIN Things t ON t.fk_rooms = r.id
  </code></pre>
  
  <p>which in my case works perfectly except for a few that have many to one relationship with the "Rooms" table. So instead of new rows in the result set holding the different names for "People" and "Things" in relation to the "Rooms" table, I would like to receive only two rows:</p>
  
  <pre><code>1. kitchen, John, Andy, Laura, sink
  2. bedroom, Mary, TV, bed
  </code></pre>
  
  <p>A <code>GROUP BY</code> on r.id will only <code>select</code> one row from each table. Any help is highly appreciated!</p>