Nadya,

One more idea (for the future) would be to use the LOOKUP() function, as long as you're working in VFP.


>>Maybe try by dropping the DISTINCT and add a GROUP BY CCODE clause at the end.
>
>This solved the problem.
>

>  select nvl(State,lcState) as State, ;
>		nvl(upper(County),lcCounty) as County, ;
>		lcCity as City, ;
>		curTemp.ccode, curTemp.town, UseGrp, cYear, ;
>		VolSales, MedSale, NumSales ;
>	 	from curTemp left join Towns on curTemp.ccode=Towns.ccode;
>	 	group by 4,5,6,7 ;
>	 	into cursor curWork	

>
>Thanks to everyone.