>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

Try this:

CLOSE ALL
OPEN DATABASE CATALOGUE EXCL
DROP VIEW ThisView
VALIDATE DATABASE RECOVER
PACK DATABASE

CREATE SQL VIEW ThisView AS ... < your code from above >