Tricky SQL question

From: Joost Ouwerkerk <joost.ouwerkerk_at_sickkids.on.ca>
Date: 1998/11/04
Message-ID: <3640a959.4517586_at_resunix.sickkids.on.ca>#1/1


[Quoted] [Quoted] Given two tables: people (Person, ID) and attributes (ID, attribute)

[Quoted] [Quoted] A person can have any number of attributes:

ID Attribute
--- ---------
123 Man
123 Actor
123 Consumer

How can I get the following output using only SQL (SQL*Plus):

Person                     ID  Attributes
-------------------------- --- ---------------------------------
Joe Jones                  123 Man, Actor, Consumer
Mary Walsh                 234 Woman, Comedian, Writer, Director
Jackie Chan                456 Man, Martial Artist
Larry Sanders              678 Man, Comedian, Producer

The attributes must be on one line and separated by commas. Is this even possible?

Joost Ouwerkerk
Hospital For Sick Children Foundation
Toronto, Canada Received on Wed Nov 04 1998 - 00:00:00 CET

Original text of this message