I need to get all records that has no reference in same table?
DicWords: DicWordID - ParentDicWordID
I need to list all records in Words where DicWordID not in ParentDicWordID
I use this:
select * from DicWords
where DicWordID not in (select ParentDicWordID from DicWords )
another saying : select all records has no Childe