>>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:)

Keep in mind that SET DELETE ON is scoped to the datasession.