>>Nope. I tested with two tables this morning. As long as I select what I need from each with 'deleted() as ldeleted' code into intermediate tables, and then join those, it works just fine.
>>
>Post this select, please.
The point is, it's not just one select. For example:
Select field1, field2, field3, field4, deleted() as ldeleted1 ;
from table1 into cursor1 where field1 = x
Select field1, field2, field3, deleted() as ldeleted2 ;
from table2 into cursor2 where field1 = x
select a.*, b.* from cursor1 a, cursor2 b into cursor3 where a.field1 = b.field1
Now do whatever with cursor3 using ldeleted1 and ldeleted2 if necessary.
Even with the intermediate steps, as long as it's optimised and I don't have to worry about a deleted() tag, it's fast.
>
>BTW,
>
http://www.jpost.com/servlet/Satellite?c=JPArticle&cid=1153291979688&pagename=JPost%2FJPArticle%2FShowFullYou think they can help my SQL problem? ;)