Hi all,
Here's my problem. I have a hierarchy of tables, each related M:M.
A <-> B <-> C <-> D <-> E
My task is: Given a single record X in table A, find all records in E which
are not linked by any path to A.
The first thing that comes to my mind is how to get the inverse:
SELECT E.NAME FROM A,B,C,D,E WHERE A.RecID = xxx
If I were working with VSDK, I could use bitset operations and just invert my
results. Is there a better SQL statement I can use? Or is there any chance,
Ruslan, that you could throw in a command to invert a cursor in VXCMD?
Thanks,
Brian
©2001 Yennie .AT. aol D.OT com |
