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