Hi everybody,

It's always simpler to answer somebody's else questions... :)

Ok, there is a problem:
I have a table with this structure

ccode C2 town C4 UseGrp C3 cYear c4 Period C2 other numeric values

I do:

select ccode, town, UseGrp, cYear, ;
		VolSales, MedSale, NumSales ;
		from InputTable ;
		where town='ZZZZ' and ;
    	Period='YR' and between(cYear,lcStartYear,lcEndYear) ;
		into cursor curTemp  && This cursor would contain all necessary records in the ascending order (Since the stats table was prepopulated)
?_Tally	

_Tally returns 255 records

Now I want to join to Towns table to add county C 15 for this table.
I do :

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

Now my result returns 5755 records.

I just want the same 255 records with one additional field included.
Note, BTW, that the InputTable contains ZZ as ccode for state level. Towns table doesn't contain ZZ, so what's why I tried left join.

Could you please help me with this SIMPLE problem? I spent already about 1h on it :(