Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Distinct and Grouping 1

Status
Not open for further replies.

xxing

Programmer
Feb 17, 2004
61
NZ
Hi

I have a table with this

Activity ID
1 1
1 2
1 3
2 4
2 5
3 6
4 7
4 8

I want to see this

Activity ID
1 1,2,3
2 4,5
3 6
4 7,8

Each activity has the ID's associated with them

Thank you for help

Regards
Mark
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top