Re: SQL Question

Is this a homework assignment? If so ... sorry but no help from me beyond the following:

Look at the DECODE function.

Daniel Morgan

Prasad G wrote:

> I have the following situation:
>
> Table:
> --- ------ ----
> ID Rel_ID Name
> --- ------ ----
> A1 B1 X1
> B1 C1 X2
> C1 D1 X3
> D1 - X4
> A2 B2 Y1
> B2 C2 Y2
> C2 - Y3
> --- ------ ----
>
> Result that I want:
> --- ----- ----- ----- -----
> ID Name1 Name2 Name3 Name4
> --- ----- ----- ----- -----
> A1 X1 X2 X3 X4
> A2 Y1 Y2 Y3 -
> --- ----- ----- ----- -----
>
> How should I go about doing this report?
>
> Prasad
Received on Fri Mar 22 2002 - 11:28:17 CST