Dawa,

You can not use the alias in your AS clause. That is a whole seperate error.

If the missing commas are intended to be AS items you should drop the lcAlias from there.

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

>Look at the third line in the code, that should be a syntax error.
>

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