Multiple records one column separated by comma (,)

[visopenlive]

Hai all

I am working on something like this. Hope someone can help me.
Consider this as sample data

Field1 Field2
John GA
Mark FL
Steve MI
John CA
John IL

Can someone assist me on a query to have data like this?

Field1 Field2
John GA, CA, IL
Mark FL
Steve MI

Thanks a lot..

 

[snitin78]

What kind of database are you using? Microsoft, Oracle..?? There might be easy solutions depending on the database you are using.

Nitin

 

[rejkonto]

According Oracle, this is best I know:

http://www.oracle-base.com/articles/misc/StringAggregationTechniques.php

A.

 

[Wallie12]

Yes, I encounter this problem.
Handled it two ways:
1. Importing through MS Access to DBMS
2. Changing the column deliminator to something else, like |