0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for music historians, critics, and fans

select distinct p.id, STUFF(
             (SELECT ',' + tagname 
              FROM tags
              FOR XML PATH (''))
             , 1, 1, '')

from posts p

join posttags pt on pt.postid=p.id
join tags t1 on t1.id=pt.tagid

where p.id=231767

fork query

edited oct 20 17

created oct 20 17 anonymous