Re: Create Multi record

mhakimjavadi_at_hotmail.com (Mohammad) wrote in message news:<cc59b627.0403251102.65817289_at_posting.google.com>...
> Hi
>
> I am very new in SQL and i need you help.I have record like :
>
> IDNUM1 XX YY ZZ (one record FOR ONE IDNUM)
> IDNUM2 XX YY ZZ
> and I have to make new table of those record like this : (three record
> for one IDNUM)
>
> IDNUM1 XX
> IDNUM1 YY
> IDNUM1 ZZ
> IDNUM2 XX
> IDNUM2 YY
> IDNUM2 ZZ
>
> Please advise.
>
> Thanks a lot

/* NOT TESTED */
CREATE TABLE NUMBERS(N NUMBER(1));

INSERT INTO NUMBERS VALUES(1);
INSERT INTO NUMBERS VALUES(2);
INSERT INTO NUMBERS VALUES(3);

SELECT
IDNUM,
CASE

WHEN NUMBERS.N=1 THEN XX
WHEN NUMBERS.N=2 THEN YY
WHEN NUMBERS.N=3 THEN ZZ