SQL appending result rows

[xoxoxoxoxoxox]

Hi, Is there anyway to append query result rows together in SQL? For example, i want to append/concatenate all rows with same id. Table: id column1 column2 column3 1 a b c 1 d e f 2 g h i 2 k l m Result: id column1 column2 column3 column4 column5 column6 1 a b c d e f 2 g h i k l m I'll appreciate any help. Thanks

[Stathread]

Are you wanting to update the table to have "6" columns with a value in each, do you want to just view the "results" in 6 columns or do you want 1 column with all values "appended" together?

[xoxoxoxoxoxox]

Thank you for your response. I want to view the result in 6 columns.