Using COALESCE directly within a SELECT to return comma separated values from another table

Question

I am trying to retrieve a list of comma separated product categories for a product.

Here is an idea of what I am trying to do:

SELECT *, (
  SELECT CategoryName 
  FROM ProductCategories pc 
  WHERE p.ProductId=pc.ProductId) as ProductCategories
FROM Products p

I need the product categories to be in a comma separated list. Is there a way to do it using COALESCE?

No, not using `coalesce()`. But, if you google something like "SQL Server string aggregation", you'll find that this question has been asked before. — Gordon Linoff, Jun 17 '15 at 14:17

score 1 · Answer 1 · edited May 23 '17 at 11:51

1

No, you can't use COALESCE to do that. COALESCE just returns the first non null argument that you pass it.

edited May 23 '17 at 11:51

Community

answered Jun 17 '15 at 14:18

Bill Gregg

1 Answers1