Concatenate may rows into a single text string having 2 tables

Question

Good morning. I would like to concatenate may rows into a single text string having 2 tables

Table1

ID   Use
1    A
1    A
1    B
2    A
2    B
2    C
2    B

Table2

ID   Cod_Sig
1    Nat
2    Nono

I would like to have a result like this:

Cod_Sig  Uso
Nat      A, B
Nono     A, B, C

Can anyone help me? Thanks.

Please add the database you're using. Also add the the query you've tried so far. — Harshil Doshi, Oct 20 '17 at 15:01
Which database are you using. and what have you tried so far? — Sentinel, Oct 20 '17 at 15:03
Possible duplicate of [Concatenate many rows into a single text string?](https://stackoverflow.com/questions/194852/concatenate-many-rows-into-a-single-text-string) — CDspace, Oct 20 '17 at 15:38

Harshil Doshi · Answer 1 · 2017-10-20T16:37:05.077

0

If you are using Mysql then following query will work:

select 
  t2.cod_sig,
  group_concat(distinct t1.use 
               order by t1.use
               separator ',') as uso
from Table1 t1
inner join Table2 t2
on t1.id = t2.id
group by t2.cod_sig

Click here for Demo

Hope it helps!

edited Oct 20 '17 at 16:37

answered Oct 20 '17 at 15:05

Harshil Doshi

3,497
3
14
37

Thanks.I tried to run it, but it says there´s something missing. – Luís Ruivinho Oct 20 '17 at 15:32
Let me draw again the tables: Table 1 2 fields: ID Use 1 A 1 A 1 B 2 A 2 B 2 C 2 B Table2 ID Cod_sig 1 Nat 2 Nono – Luís Ruivinho Oct 20 '17 at 15:34
The results should be like this: Cod_sig Use Nat A, B Nono A, B, C – Luís Ruivinho Oct 20 '17 at 15:39
Are you still interested in resolving this issue? – Harshil Doshi Oct 22 '17 at 13:27

Concatenate may rows into a single text string having 2 tables

1 Answers1