>Renaming the "Selections" table seems to make the error go away. I first tried to rename it to "xyz", and that worked. Then, I renamed it to "Selectionz", but that failed. I then renamed it to "Celections", which worked. Maybe FoxPro is seeing the first few characters of the table name, and interpreting it as a SELECT statement?
>
>>Can anybody tell me why this is invalid? I can run it, I just can't save it.
>>
>>
>>SELECT Selections.*, Catalogue.cproduct;
>> FROM catalogue!catalogue INNER JOIN catalogue!selections ;
>> ON Catalogue.iid = Selections.iproductid
I think you are right. That finally worked for me. I am very careful not to use reserved words, but this one thre me for a loop!