>Hello,
>
>How to create a new cursor like the table2 below from table1 ?
>
>Any help or suggested coding would be appreciated
>
>TIA
>
>TABLE1
>
>Level1 level2 level3 Desc
>010 AAA
>010 002 BBBBBB
>010 002 005 CCCCCCCCC
>010 002 013 DDDDDDDDD
>010 002 015 EEEEEEEEE
>010 002 016 FFFFFFFFF
>010 002 018 GGGGGGGGG
>010 003 HHHHHH
>010 003 005 JJJJJJJJJ
>010 003 017 KKKKKKKKK
>010 003 028 LLLLLLLLL
>010 003 072 MMMMMMMMM
>010 003 084 NNNNNNNNN
>010 003 085 OOOOOOOOO
>010 003 086 PPPPPPPPP
>010 003 087 RRRRRRRRR
>010 003 088 SSSSSSSSS
>010 003 089 TTTTTTTTT
>---------------------------------
>TABLE2
>
>Desc1 Desc2 Desc3
>AAA BBBBBB CCCCCCCCC
>AAA BBBBBB DDDDDDDDD
>AAA BBBBBB EEEEEEEEE
>AAA BBBBBB FFFFFFFFF
>AAA BBBBBB GGGGGGGGG
> >AAA HHHHHH JJJJJJJJJ
>AAA HHHHHH KKKKKKKKK
>AAA HHHHHH LLLLLLLLL
>AAA HHHHHH MMMMMMMMM
>AAA HHHHHH NNNNNNNNN
>AAA HHHHHH OOOOOOOOO
>AAA HHHHHH PPPPPPPPP
>AAA HHHHHH RRRRRRRRR
>AAA HHHHHH SSSSSSSSS
>AAA HHHHHH TTTTTTTTT

CREATE CURSOR Table1 (Level1 C(3),level2 C(3), level3 C(3), Desc C(40))

INSERT INTO Table1 VALUES('010','','','AAA')
INSERT INTO Table1 VALUES('010','002','','BBBBBB')
INSERT INTO Table1 VALUES('010','002','005','CCCCCCCCC')
INSERT INTO Table1 VALUES('010','002','013','DDDDDDDDD')
INSERT INTO Table1 VALUES('010','002','015','EEEEEEEEE')
INSERT INTO Table1 VALUES('010','002','016','FFFFFFFFF')
INSERT INTO Table1 VALUES('010','002','018','GGGGGGGGG')
INSERT INTO Table1 VALUES('010','003','','HHHHHH')
INSERT INTO Table1 VALUES('010','003','005','JJJJJJJJJ')
INSERT INTO Table1 VALUES('010','003','017','KKKKKKKKK')
INSERT INTO Table1 VALUES('010','003','028','LLLLLLLLL')
INSERT INTO Table1 VALUES('010','003','072','MMMMMMMMM')
INSERT INTO Table1 VALUES('010','003','084','NNNNNNNNN')
INSERT INTO Table1 VALUES('010','003','085','OOOOOOOOO')
INSERT INTO Table1 VALUES('010','003','086','PPPPPPPPP')
INSERT INTO Table1 VALUES('010','003','087','RRRRRRRRR')
INSERT INTO Table1 VALUES('010','003','088','SSSSSSSSS')
INSERT INTO Table1 VALUES('010','003','089','TTTTTTTTT')

SELECT	;
	T1.Desc Desc1;
,	T2.Desc Desc2;
,	T3.Desc Desc3;
FROM		Table1 T3;
	JOIN	Table1 T1	ON T1.Level1=T3.Level1 AND T1.Level2='   '		AND T1.Level3='   ';
	JOIN	Table1 T2	ON T2.Level1=T3.Level1 AND T2.Level2=T3.Level2	AND T2.Level3='   ';
WHERE NOT T3.level3='   ';
ORDER BY 2,3