posted 18 years ago
The result set like below
L1 L2 L3
1 11 111
1 11 112
1 12 121
1 12 123
...
2 21 211
2 21 222
........
Need to output as tree,
output as tree,
L1 L2 L3
1 11 111,112
12 121,123
2 21 221, 222
..........
I can think the basic idea for that to convert it as tree, but a lot of checking and seems very complexity.
it seems a general operation after DB extraction and wonder if there is better or existing soluation?
Thanks!
[ July 18, 2005: Message edited by: Steve Jiang ]