Okay - sorry for all the messages - but - here are the steps to reproduce:

1. Create two tables (table1 and table2) with 15 fields (f1, f2...f15) each. Each field should be a C(10) field. No indexes needed to reproduce.
2. Create a DBC and add the two tables to the DBC
3. Add 600000 blank records to each table
3. Create a local view on the two tables with an inner join on the first field (f1)
4. Select "*" or All fields in the View Designer
5. Close the View Designer

After naming the view, you should get the 'SQL too complex' message.

If you select all fields from table1 and the first 12 fields from table2, the view will work.

If you delete 50000 recs from table1, the view will work with all fields selected.

Hope that helps.

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