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