vertical to horizonal

Hi everybody. I got a real tricky question here.

Suppose i have 3 tables

Persons
ID Name
1 Frank
2 Joe
3 Dan

Hobbies
1 Basketball
2 Football

Persons_Hobbies
1 1
1 2
2 2
3 1

which means that Frank plays Basketball and Football......

Is there any way to put this on row? The result should be

Frank Basketball Football

Joe        Football
Dan        Basketball

Thanks for your help

Joerg Received on Wed May 05 1999 - 12:01:23 CDT