Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL puzzle -- flattening a parent child relationship
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.
-- Galen deForest Boyer Sweet dreams and flying machines in pieces on the ground.Received on Tue Apr 02 2002 - 20:46:05 CST