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

>
Ah, OK. These selects will work fine.

>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%2FShowFull
>
>You think they can help my SQL problem? ;)

No, but they can help Israel.