SELECT t1.description as t1desc,
STUFF((SELECT ',' + description FROM table2 WHERE id = t1.id FOR XML PATH('')),1,1,'') AS descriptions
FROM table1 t1

quote:

---

Originally posted by visakh16

SELECT t1.description as t1desc,
STUFF((SELECT ',' + description FROM table2 WHERE id = t1.id FOR XML PATH('')),1,1,'') AS descriptions
FROM table1 t1

I've assumed column names so make sure you put correct column names instead

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---