Combining records

Good day
I have a SQL results set that looks like this:
CandidateID Nationality
90509 SA
90509 UK
90509 IT
90509 FR
I need my results to look like this:
CandidateID Nationality
90509 SA, UK, IT, FR
Is this possible? What approach should I take to accomplish this?
Thanks and kind regards,
KarlKarl,
Better if you do it in your client app / reporting tool / programming
lenguage. There are a lot of cons to do it in t-sql. See if this helps.
http://groups-beta.google.com/group...
5bf366dd9e73e
AMB
"Karl Basson" wrote:

> Good day
> I have a SQL results set that looks like this:
> CandidateID Nationality
> 90509 SA
> 90509 UK
> 90509 IT
> 90509 FR
> I need my results to look like this:
> CandidateID Nationality
> 90509 SA, UK, IT, FR
> Is this possible? What approach should I take to accomplish this?
> Thanks and kind regards,
> Karl
>
>