|
|
|
Forum Newbie
Group: Forum Members
Last Login: 3/30/2007 2:32:00 AM
Posts: 2,
Visits: 1
|
|
Hi Guys,
I need help with the following please;
I’ve got a table that looks like this,
ID NO NAME MAKE YEAR
1 John Blue 2000
1 John Blue 2001
1 John Blue 2003
2 Mary Black 1999
2 Mary Black 2001
3 Gerry Silver 2002
3 Gerry Silver 2003
3 Gerry Silver 2004
3 Gerry Silver 2005
The output must be like the following
ID NO NAME MAKE YEAR
1 John Blue 2000,2001,2003
2 Mary Black 1999,2001
3 Gerry Silver 2002.2003,2004,2005
Any help would be appreciated
Many thanks
Dan
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 7/22/2008 3:48:36 AM
Posts: 173,
Visits: 5
|
|
|
|
|