select * rows has no Childe
Dear all,
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
thanks
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
thanks
ASKER
Words is same DicWords
when I use :
select * from DicWords
where DicWordID not in (select ParentDicWordID from DicWords )
it return nothing
where :
select * from DicWords where DicWordID=878251 return a record
and
select * from DicWords where ParentDicWordID=878251 return nothing
when I use :
select * from DicWords
where DicWordID not in (select ParentDicWordID from DicWords )
it return nothing
where :
select * from DicWords where DicWordID=878251 return a record
and
select * from DicWords where ParentDicWordID=878251 return nothing
ASKER
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
>I need to list all records in Words
Is Words a separate table?