>Thanks Hilmar. I added a flag field to the original table and copied deleted() into it. That gave me what I needed.
>btw - set deleted off was in effect. :)
Sure, but I don't think you need a separate field - not in the original table. What I had in mind was simply to separate the query into more than one query, selecting only a single table in the first query. More or less like this:
select system, rtp_id, ... deleted() as del1;
from rtp_projects;
into cursor temp
select temp.*, r2.rtp_id, ...;
from temp r1 join rtp_projects r2 on ...;
into cursor temp2
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
