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


I'll jump in with my guess.

Towns.ccode is not unique. The town code is repeated for each state (perhaps for each state/county??) and you are pulling multilpe records from the towns file.


Just a hunch.........Rich