David,

Yes, I must go wash my glasses. I did not notice the , after d, however I recently updated my message because at first I did not notice the missing , after filenum.

>Tore,
>
>>As far as I can see, there is no error in your code,
>
>well there are two errors in the code. 1) the missing , between b and c which won't throw an error as you explained and 2) the extra , after the d
>
>so why do you expect an error message? Are you aware that AS is not required in the field list? So VFP treats your Select command like this:

>>SELECT &lpcAlias..filenum ;
>>	&lpcAlias..a, ;
>>	&lpcAlias..b AS	&lpcAlias..c, ;
>>	&lpcAlias..d, ;
>>	FROM  &lpcAlias ;
>>	ON &lpcAlias..id = m.lpnid;
>>	INTO CURSOR curTemp NOFILTER
>>