I have a table that stores user comments, the table is very simple 3 column table: commentid, customerid, comment. I need to show all comments made by one customer as 1 line. When I do something like:
SELECT comment FROM [COMMENTS] WHERE customerid=12
I get 21 rows of all the historical comments. I need to concatenate all these entries into 1 row for output.