I've created a simple query that I have 3 or 4 records returned.
SELECT Distinct at.Attachment_Filename AS attachment_files, oh.Order_Number AS Order_Number FROM dbo.Order_Detail od LEFT OUTER JOIN dbo.Order_Header oh ON od.Order_Header_ID = oh.Order_Header_ID LEFT OUTER JOIN dbo.Attachment at ON oh.Order_Header_ID = at.Order_Header_ID WHERE oh.Order_Number = '80237'
123456 | 80237
789012 | 80237
345678 | 80237
I'm needing results to show as
123456, 789012, 345678 | 80237
I'm running an older version of Vineyard Knowledgesync, and I believe it's using SQL 2005. So STUFF doesn't appear to work. Any help would be appreciated.