I see Aleksey has responded on this issue and has logged it in our internal tracking system.

But, besides that, how realistic is this scenario? You have two tables of 600,000 records that you're joining on a fields that contain blanks, setting up a situation where there's an unholy number of possible combinations.

>I figured out how to produce code to show the problem. Here is the code that will work in VFP8 but not in VFP9. Thanks for taking a look at it.
>
>CLOSE TABLES all
>
>DELETE FILE test.dbc
>DELETE FILE table1.dbf
>DELETE FILE table2.dbf
>
>CREATE DATABASE test
>OPEN DATABASE test EXCLUSIVE
>
>CREATE TABLE table1 ;
>(f1 c(10), ;
>f2 c(10), ;
>f3 c(10), ;
>f4 c(10), ;
>f5 c(10), ;
>f6 c(10), ;
>f7 c(10), ;
>f8 c(10), ;
>f9 c(10), ;
>f10 c(10), ;
>f11 c(10), ;
>f12 c(10), ;
>f13 c(10), ;
>f14 c(10), ;
>f15 c(10))
>
>
>CREATE TABLE table2 ;
>(f1 c(10), ;
>f2 c(10), ;
>f3 c(10), ;
>f4 c(10), ;
>f5 c(10), ;
>f6 c(10), ;
>f7 c(10), ;
>f8 c(10), ;
>f9 c(10), ;
>f10 c(10), ;
>f11 c(10), ;
>f12 c(10), ;
>f13 c(10), ;
>f14 c(10), ;
>f15 c(10))
>
>SELECT table1
>
>FOR lnLoopCount = 1 TO 600000
>
>APPEND BLANK
>
>NEXT
>
>GO TOP
>
>SELECT table2
>
>FOR lnLoopCount = 1 TO 600000
>
>APPEND BLANK
>
>NEXT
>
>GO TOP
>
>MESSAGEBOX("Here goes...begin view creation")
>
>CREATE SQL VIEW v_test as ;
>SELECT * ;
>FROM ;
>test!table1 ;
>INNER JOIN test!table2 ;
>ON Table1.f1 = Table2.f1
>
>CLOSE TABLES all
>CLOSE DATABASES
>
>
>>Sure, send it to me with instructions as to where the failure is.
>>
>>>I've got a project zipped up with the files necessary to reproduce this. If you'd like, I can send it to you. It's around 38MB's though... I can send it to you on a CD it you'd like - just need an address. I can also try to email it if you'd like.
>>>
>>>>Hmmmm...
>>>>
>>>>Can't find any bugs in our database related to this and I also can't repro using any of the tables or view from the Northwind database. Ummm...there should be spaces between the end of the lines and the semi-colon but that's probably just the way it went into this post?
>>>>
>>>>Could you go to the VD, right-click to pull up SQL, and cut and paste the exact SQL? Thanks.
>>>>
>>>>
>>>>
>>>>>I'm trying to upgrade my app to VFP9 from VFP8. It's giving me the "SQL expression is too complex" on this view:
>>>>>
>>>>>SELECT *;
>>>>> FROM ;
>>>>> mc!pbrwork ;
>>>>> INNER JOIN mc!pbrmain ;
>>>>> ON Pbrwork.pbrmainfk = Pbrmain.primarykey;
>>>>> WHERE Pbrwork.pbrmainfk = ( ?lnPBRMainFK );
>>>>> ORDER BY Pbrwork.pbrmainfk, Pbrwork.linenumber
>>>>>
>>>>>Any ideas?