Combing records

[PURDURANGO]

I am a newbie to both SQL and Dreamweaver. I am creating a website that will list users from my database. I have created a view that looks like this

id name BusArea BusAreaID
1 tina Web 1
1 tina Mort 2
1 tina Strong 3
2 Jim Web 1

I want the out put to be all the records associated with the "ID" field. What I am getting is 3 individual records. How do I combine all the records associated with the "ID" without duplicating? I would love to have the busArea as a list. Is this possible?

[KDLA]

How do I combine all the records associated with the "ID" without duplicating?
You need to filter your query so it will not show duplicates.

[landslide]

you can do a SQL "LIKE" statment that may work.