Hello, everyone:

I have a table like:

Col1 Col2
1 A
2 B
1 D
1 P
2 F
2 W

How to query this table to return by Col1 like

Col1 Col2
1 A,D,P
2 B,F,W

Thanks a lot
ZYT