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'