Yes, sorry.
Luis
>I think he meant:
>
>
>Select pbrwork.*, pbrmain.*
>
>
>Richard
>
>
>>It says it doesn't 'recognize' SELECT *.pbrmain... as valid...
>>
>>>Try
>>>>SELECT *.pbrwork, *.pbrmain;
>>>> FROM ;
>>>> mc!pbrwork ;
>>>> INNER JOIN mc!pbrmain ;
>>>> ON Pbrwork.pbrmainfk = Pbrmain.primarykey;
>>>> WHERE Pbrwork.pbrmainfk = ( ?lnPBRMainFK );
>>>> ORDER BY Pbrwork.pbrmainfk, Pbrwork.linenumber
>>>
>>>
>>>Luis Navas
>>>
>>>>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?
I never forget a face, but in your case I will make an exception :-)