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