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'