I get the error both when trying to create the view and when the view is used/requeried.

I am working on code to reproduce - will get that to you when complete. See message to John Koziol for more information about this problem.

>Hi Howard,
>
>When do you get this error, on CREATE SQL VIEW command or on USE command?
>
>Could you put small, but complete repro together? The repro should create .DBC, create tables, add some data (if required in order to get the error), create the view, ...
>
>Thanks,
>Aleksey.
>
>
>>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?