>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.