Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL puzzle -- flattening a parent child relationship

Re: SQL puzzle -- flattening a parent child relationship

From: Galen Boyer <galendboyer_at_yahoo.com>
Date: 2 Apr 2002 20:46:05 -0600
Message-ID: <u1ydxe3g5.fsf@rcn.com>


On 2 Apr 2002, jpink_at_liquidaudio.com wrote:

> Is it possible using just (Oracle) SQL to join these tables and return
> a single record for each parent? The desired results for this example
> are:
>
> 1,A,X,Y,Z
> 2,B,X,Y

AskTom is your friend.

I think this is what you are looking for.

http://asktom.oracle.com/pls/ask/f?p=4950:8:53637::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:229614022562,%7Btranspose%7D

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.
Received on Tue Apr 02 2002 - 20:46:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US