>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
>
-snip-
Oscar,
Would a query that searches for those iid's who aren't nobody's iidparents work? For example:
Select * from selfrefer ;
Where iid not in (Select Distinct iidparent From selfrefer)