Set Ansi On - shows the exact same things now in sys(3054) and works just as fast.

Here is the link:
http://www.ms-news.net/f1342/strange-behaviour-when-joining-2-tables-10694727.html

I actually remember this now. But it's been so long!

>>Checking sys(3054,11) :
>>VFP 8.0 - Shows no optimization but uses a temp index.
>>VFP 9.0 - Shows no optimization but shows (Cartesian product)
>>
>>I found this thread. Seems to be the same issue I'm seeing.
>>http://www.dbmonster.com/Uwe/Forum.aspx/foxpro/5717/VFP9-SQL-statement-problem
>>
>>I'm still researching.
>>
>Just in case - are you using VFP9 SP2 latest hotfix? Do you have indexes with variable length? If yes, then it's another problem, which you better fix ASAP.