Query Help

Sample table:

ID----------ITEM

1           knife
1            fork
1           spoon
2           fork
2           spoon
3           fork
4           knife
4           fork
4           spoon

Required output for csv file:

1 knife fork spoon
2 fork spoon
3 fork
4 knife fork spoon

Is this even possible, if so how would the SQL query look?

Thanks in advance for your time. Received on Thu Jan 25 2007 - 12:08:40 CST