Xref: alice comp.databases.oracle.misc:30557 comp.databases.oracle.server:48322
Path: alice!news-feed.fnsi.net!netnews.com!news.maxwell.syr.edu!newsfeed.nacamar.de!rz.uni-karlsruhe.de!news.uni-stuttgart.de!news.belwue.de!LF.net!not-for-mail
From: "Joerg Leute" <leute@itdesign.de>
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc
Subject: vertical to horizonal
Date: Wed, 5 May 1999 19:01:23 +0200
Organization: LF.net GmbH, Stuttgart, Germany
Lines: 34
Message-ID: <7gpte0$23j7$1@news.lf.net>
X-Trace: news.lf.net 925923584 69223 194.55.101.195 (5 May 1999 16:59:42 GMT)
X-Complaints-To: usenet@news.LF.net
NNTP-Posting-Date: 5 May 1999 16:59:42 GMT
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

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