>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
>?_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 sure sounds like you've got a bunch of records that match in the towns table and are not duplicates.
How unique is the ccode field in each table? With only 2 characters, it probably isn't unique enough to distinguish a single record.
Insanity: Doing the same thing over and over and expecting different results.