>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 >
Mark McCasland
Midlothian, TX USA