title: SQL How to join 2 row?
body: <p>after doing this request i got the tab like this </p>
  
  <pre><code>Jumanji 2019    Action  Jan de  Bont
  Jumanji 2019    Action  Jake    Kasdan
  Jumanji 2019    Action  Dwayne  Johnson
  Jumanji 2019    Comedie Jan de  Bont
  Jumanji 2019    Comedie Jake    Kasdan
  Jumanji 2019    Comedie Dwayne  Johnson
  Speed 2 1997    Action  Sandra  Bullock
  Speed 2 1997    Action  Jason   Patric
  </code></pre>
  
  <p>How i can join the third comumn like </p>
  
  <pre><code>Jumanji 2019    Action,Comedie  Jan de  Bont
  Jumanji 2019    Action,Comedie  Jake    Kasdan
  Jumanji 2019    Action,Comedie  Dwayne  Johnson
  Speed 2 1997    Action          Sandra  Bullock
  Speed 2 1997    Action          Jason   Patric
  </code></pre>
  
  <p>here is my query: </p>
  
  <pre><code>SELECT DISTINCT MEDIA.media_Titre, MEDIA.media_AnneeSortie,
         GENRE.genre_Nom,
         PERSONNE.personne_Nom, PERSONNE.personne_Prenom
  FROM MEDIA, MEDIA_GENRE, METIER, ROLE, GENRE, PERSONNE 
  WHERE MEDIA.typeMedia_Id=1 AND
        (MEDIA_GENRE.media_Id = MEDIA.media_Id AND 
         MEDIA_GENRE.genre_Id = GENRE.genre_Id
        ) AND
        (ROLE.artiste_Id = PERSONNE.personne_Id AND
         ROLE.media_Id = MEDIA.media_Id
        )
  </code></pre>