db2合并某字段多列值用逗号分割

Question

A、B两张表
A表数据
a b

1 1

3 3

B表数据
a c
1 1
1 2
3 3

db2要求结果
a b c
1 1 1,2
3 3 3

Answer 1

SELECT A.a,A.b,GROUP_CONCAT(B.c) FROM A INNER JOIN B ON A.a=B.a GROUP BY A.a;