>>>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 >
>
>Thanks, Mark. That didn't work. This is a pretty straight-forward join. I wonder what the problem is?

After the error is generated, what do the elements of the array laError return from aerror(laError)?