this is a very common request and there is no easy way to do it in TSQL. You can use the FOR XML option to return an XML fragment containing the information:
<customer id="10">
<phones>
<phone>954-565-5496</phone>
<phone>954-549-6446</phone>
</phones>
...
</customer>
-Mike
>I have this problem.
>
>Let's say I have a customer table and I'm joining to a customer_phones table and also to an customer_nicknames table.
>
>Now I want the result to look like this, somehow combining the phone numbers into one field and combining the nicknames into another field, basically one row per customer.
>
>nCus_id: 10
>cPhones: '954-546-5496,954-549-6446'
>cNickNames: 'rico,tommy,rock'