So i ended up going with a union query that syncs grouped by carbon_copy_id and one without and it seems to be doing the job.

Thanks guys for getting me...

I think what I need to do here is two queries and union the two.

There are two scenarios, a message from one sender to one recipient.

A message from one...

Thanks guys. We're a little bit closer.

So I tried your query. It worked in that it produced the comma delimited list, which is great.

The 2nd part of it is...

Its not stored as comma delimited values. I'm saying I want the query to produce a comma delimited list based on the join while simultaneously combining records that share a...