Here is a sample of my table:
ID Name Codes
1 John D S12, S13, S89
1 John D S98, T12
2 Joe D X27, S28
3 Bob S F12, F13, X43
3 Bob S S44, X38, S90
4 Steve F D25
I want a query that will return the following
ID Name Codes
1 John D S12, S13, S89, S98, T12
2 Joe D X27, S28
3 Bob S F12, F13, X43, S44, X38, S90
4 Steve F D25
Any ideas?