>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
Hi Jim.
The problem seems to be related to having the catalogue table be the same name as the database. I created a DBC with these two tables and also couldn't get the view to save. I renamed the table to catalog and then it saves just fine.
Dan