>>>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.
If it's not broken, fix it until it is.
My Blog