Hi Crescencio

A simplified structure in order to sample what I need looks like this :

(iid i, ;
iidParent i,
cAccount c(40))

Where iidParent contains a reference to iID (the parent), this defines the parent-child relationship.

Right now I'm trying a sets difference by using the NOT IN clause of the sql-statement.


Oscar

>>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?