title: Selecting one cell once, but everything else
body: <p>I have two tables:</p>
  
  <pre><code>      groups                  group_members
      v-------------------------------v
   +----+------------+     +----+----------+------+
   | id | group_name |     | id | group_id | name |
   +----+------------+     +----+----------+------+
   | 1  | admin      |     | 1  | 1        | Dave |
   +----+------------+     +----+----------+------+
   | 2  | moderator  |     | 2  | 1        | Bob  |
   +----+------------+     +----+----------+------+
   | 3  | vip        |     | 3  | 2        | Sue  |
   +----+------------+     +----+----------+------+
   | 4  | user       |     | 4  | 2        | Jill |
   +----+------------+     +----+----------+------+
                           | 5  | 2        | Jack |
                           +----+----------+------+
                           | 6  | 3        | Bill |
                           +----+----------+------+
                           | 7  | 4        | Sam  |
                           +----+----------+------+
  </code></pre>
  
  <p><code>group_members</code> has a foreign key reference from <code>group_id</code> to <code>id</code> in <code>groups</code>.</p>
  
  <p>I want to obtain the roster of members found in a group, but also return the <code>group_name</code> in the process. I would like to do this in one query only.</p>
  
  <p>I've tried this query but it returns the group name for every row, I'd like to see the <code>group_name</code> as its own row.</p>
  
  <pre><code>SELECT groups.group_name, 
         group_members.name 
  FROM   groups, 
         group_members 
  WHERE  group_members.group_id = groups.id 
         AND groups.id = 1 
  </code></pre>
  
  <p>The result is:</p>
  
  <pre><code>+-------------------+--------------------+
  | groups.group_name | group_members.name |
  +-------------------+--------------------+
  | admin             | Dave               |
  +-------------------+--------------------+
  | admin             | Bob                |
  +-------------------+--------------------+
  </code></pre>
  
  <p>I'd like to see:</p>
  
  <pre><code>  either this |                     or this |
                v                             v
  +-------------------+            +---------------------+
  | groups.group_name |            | groups_members.name |
  +-------------------+            +---------------------+
  | admin             |            | admin               |
  +-------------------+            +---------------------+
                                   | Dave                |
  +---------------------+          +---------------------+
  | groups_members.name |          | Bob                 |
  +---------------------+          +---------------------+
  | Dave                |
  +---------------------+
  | Bob                 |
  +---------------------+
  </code></pre>
  
  <p>Would that be possible?</p>