I have a select statement with a join condition that looks like this:
>
>>SELECT a.acct_nbr, a.holder_num, b.h_name ;
> FROM tmpCD a ;
> LEFT JOIN holders b ON a.holder_num = b.h_num ;
> INTO cursor tmpCursor
>
>
>The tmpCD file has about 1.25 million records. After running the select, the resulting cursor has 6 records more than the original tmpCD file....seems like it should be the same record count. None of the holder_num fields are empty. What am I missing here?Hi Kevin,
To one record in TmpCD you are getting as meny records in tmpCursor, as there are relevent records in holders.
HTH
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst