Concatinating Multiple Rows in SQL
- by Dave C
Hello,
I have a table structure that looks like this:
ID String
-----------
1 A
1 Test
1 String
2 Dear
2 Person
I need the final output to look like this:
ID FullString
--------------------
1 A, Test, String
2 Dear, Person
I am really lost on how to approach this... I looked on a couple examples online but they seemed to be VERY complex... this seems like it should be a real easy problem to solve in sql.
Thank you for all assistance!