title: mysql join with multiple values in one column
body: <p>I need to make a query that creates 3 columns that come from 2 tables which have the following relations:</p>
  
  <p>TABLE 1 has Column ID that relates to TABLE 2 with column ID2</p>
  
  <p>In TABLE 1 there is a column called user In TABLE 2 there is a column called names</p>
  
  <p>There can be 1 unique user but there can be many names associated to that user.</p>
  
  <p>If i do the following i get all data BUT the user column repeats itself for each name it has associated. What i want is for use to appear unique but the names columns appear with all the names associated to the user column but separated by commas, like the following:</p>
  
  <p>select user,names from TABLE1 left join TABLE2 on TABLE1.id = TABLE2.id</p>
  
  <p>This will show the users repeated everytime a name appears for that user. what i want is to appear like this:</p>
  
  <p>USER - NAMES<br>
  cyrex - pedrox, rambo, zelda<br>
  homeboy - carmen, carlos, tom, sandra<br>
  jerry - seinfeld, christine<br>
  ninja - soloboy  </p>
  
  <p>etc....</p>