sql - string equivalent of Sum to concatenate - Stack Overflow

I would like a query to output on 1 line the Id from the left table and the ... SELECT p.ID PersonID, STUFF( (SELECT ';' + b.description FROM personrole a INNER ...

stackoverflow.com