tsql concat

duplicateUpcs.sql

select 
	r.name as release,a.name as artist,r.version,l.name as label,count(distinct r.upc) as upcCount,concat(distinct r.upc) as upcs
from releases r
	join artists a on a.artistid = r.artistid
	join labels l on l.labelid = r.labelid
where l.name = 'foo'

group by r.name, a.name,l.name,r.version,upcs
having count(distinct r.upc) > 1
order by upcCount desc