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.