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?