title: SQL combining data from multiple rows in two tables into one row
body: <p>I have data from two tables in a members system as follows:</p>
  
  <pre><code>Table: listuser
  userid  listid
  ===========
  1       5
  1       8
  1       3
  2       5
  2       3
  3       4
  4       4
  5       3
  6       4
  
  Table: list
  id  name
  ==============
  3   Members
  4   Non Members
  5   Subscribers
  8   Test
  </code></pre>
  
  <p>What I am trying to achieve is a result as follows:</p>
  
  <pre><code>userid  lists
  ===================
  1       Members, Subscribers, Test,
  2       Members, Subscribers
  3       Non Members,
  4       Non Members,
  5       Members,
  6       Non Members,
  </code></pre>
  
  <p>Users can belong between 0 and n lists.
  I have tried a number of approaches, but always end up with multiple rows for userid which is what I am trying to eliminate. I would be very great full for some help.</p>