| Subject | Efficiently find records from a self join without children records or a field=1 |
|---|---|
| Author | Bhavbhuti Nathwani |
| Post date | 2009-06-21T10:28:58Z |
Hi all
I have a self-joined table to represent a hierarchical structure. Now I want a list of records that do not have children records (leaf nodes) or specifically records that have a field with a value of 1 (even though there are children recoards for them)
Thanks and regards.
Bhavbhuti
I have a self-joined table to represent a hierarchical structure. Now I want a list of records that do not have children records (leaf nodes) or specifically records that have a field with a value of 1 (even though there are children recoards for them)
Thanks and regards.
Bhavbhuti