Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Tricky SQL question
Given two tables: people (Person, ID) and attributes (ID, attribute)
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 CST
![]() |
![]() |