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

Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL Query Help

Re: SQL Query Help

From: Patrick E Finucane <finucanp_at_dsp.net>
Date: 1999/02/13
Message-ID: <36C542A2.494F022A@dsp.net>#1/1

See if a crosstab query will assist

Troy Perchotte wrote:
>
> I am trying to create a query that will change the following:
>
> PARENTID CUSTID
> 100 110
> 100 111
> 100 112
> 100 113
> 200 114
> 200 115
> 300 201
>
> Into this format:
>
> 100 110 111 112 113
> 200 114 115
> 300 201
>
> Can anyone help? Please respond here.
>
> Thanks,
>
> Troy
  Received on Sat Feb 13 1999 - 00:00:00 CST

Original text of this message

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