Hierarchy Problem

[farolito20]

ID, NAME, PARENT

1, A

2, B

2, AA, A

3, AAA, AA

4, BB, B

5, AAAA, AAA

I need this result:

LAST ID , NAME,  PARENT

5 , AAAA , 1

4, BB , 2

[#2]

Hi,

You are using the function 'Hierarchy'?

Rebeca

[farolito20]

Yes