Posts by Lázaro Dutra • 11 points

• 1

  votes

  1

  answer

  422

  views

  A: Repeated data with GROUP_CONCAT

  That was the solution SELECT contatos.cont_id, contatos.cont_firstname, contatos.cont_lastname, contatos.data_nasc, contatos.anotacoes, GROUP_CONCAT(distinct contatos_email.email),…

  sql group-concat

  answered 8 years ago Lázaro Dutra 11

• 0

  votes

  1

  answer

  422

  views

  Q: Repeated data with GROUP_CONCAT

  I have a problem when I make one SELECT in my comic book, I’m using GROUP_CONCAT to concatenate the column of phones and email but I’m picking up repeated data. Here is the SELECT: SELECT…

  sql group-concat

  asked 8 years ago Lázaro Dutra 11