>Use SET DELETE ON setting so you wouldn't need NOT DELETED() in your select. Anyway you cannot use NOT DELETED() in multi-table select because it may produce incorrect or unexpected results.
Thanks Sergey. Another lesson learned:)
- Ravi
True greatness consists in being great in little things.
- Charles Simmons