Return Single row for multiple records

[revilord]

I have table of usernames and a second table of options for the user. I want to display one row for each user and all his options.

UserTable
Users Level
Bob 1
Mark 2

Optionstable
Option Level
menu1 1
menu2 1
menu3 1
menu4 2


The result should look like this

Bob, menu1,menu2,menu3
Mark, menu4

and not
Bob menu1
Bob menu2
Bob menu3
Mark menu4

Can anyone let me know what the SQL might look like. thanks.

 

[revilord]

Actually I think I have found the answer on

http://www.tek-tips.com/viewthread.cfm?qid=1089209