>Hi everyone:
>
>I’m using a self-referenced table and I need to build a view sql-statement to retrieve only the items at the lowest level (those not having child items).
>
>I’ll greatly appreciate any hints about how to achieve it.
>
>Thanks in advance and regards.
>
>Oscar Corte

What is the structure and how is the self-reference defined on the fields?