[Solved] Hierachy

[L]

hi

I have a select statement:

Select A, B, C, D, E from TA join TB

Is it possible to do a grid hierachy example

A B C
    C D E

How should i go about it? Thanks

[Schlurk]

I believe this can be easily achieved if you do two separate select statements (A B C and C D E), however I don't think that you can use a single statement like the one you mentioned.