FWIW:
(Sorry - couldn't work out how to format it nicely...)
[font="System"]
SELECT REPLACE(RTRIM(ISNULL(BODDS+' ','')+ISNULL(CTDDS+' ','')+ISNULL(NHDDS,'')),' ',',') AS DDS
,ISNULL(BOCLEARED,0)+ISNULL(CTCLEARED,0)+ISNULL(NHCLEARED,0) AS TotalCleared
,COALESCE(BOCLEAREDDATE,CTCLEAREDDATE,NHCLEAREDDATE) AS ClearedDate FROM BO
FULL OUTER JOIN CT ON BOCLEAREDDATE=CTCLEAREDDATE
FULL OUTER JOIN...