Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sean khan
Starting Member
4 Posts |
 Posted - 2001-03-27 : 13:31:55
|
| I'm stumped on this one. I have two tables:tblTerms and tblConnectiontblTerms as the following 2 fields:termtermNumtblConnection as the following 2 fields:NTptrBTptrA query like :SELECT C.NTptr, BT.term, C.BTptr, NT.termFROM (tblTerm AS BT LEFT JOIN tblConnection AS C ON (BT.termNum = C.NTptr)) LEFT JOIN tblTerm AS NT ON (NT.termNum = C.BTptr) WHERE BT.termNum = 100Will return all the Narrower terms (NT) whose Broader term (BT) has a termNum = 100How can I figure out if the NT has children. In other words, in the same query, is there a way of determining if the BTptr is also in the NTptr list ? |
|
|
|
|
|
Mono-Hierachical Structures