I have the following query. I need to get the columng ExtContact to roll up into one row and be comma delimited.
select a.cType,vxc.ExtContact from tAction a
LEFT OUTER JOIN vActivityExtContacts vxc
ON a.nid = vxc.nidAction
Here is an idea of sample data
Current output sample