>Cindy,
>
>Actually, I tried that, but could not make it work. Could you please show me, how the code should look like it be in my case?
>
>Thanks in advance.
>
>>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.