Hi listers, I'm in need of some help with an SQL query - I just seem to get my head around it at the moment. What I have is a table with site numbers listed multiple times and attributes, eg: 1 Picnic 1 Camping 1 Bushwalking 2 Camping 2 Bird watching 3 Camping 3 Bird watching 3 Abseiling I want to group all the attributes into one field for each site, eg: 1 Picnic, Camping, Bushwalking 2 Camping, Bird watching 3 Camping, Bird watching, Abseiling Can someone help with an SQL to do this? Thanks, Chris Perry Systems Development CoOrdinator Parks Victoria Melbourne, Australia Ph: 61 3 9816 6800 Fax: 61 3 9816 9876 [EMAIL PROTECTED] ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
