result differences due to joins?

[Ruslan Zasukhin]

On 7/26/06 4:29 PM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:

Hi Florian,

I think REINDEX can help

> V1 4MD
> 
> Hi there!
> 
> I have some funny results with these sql searches:
> 
> SELECT * FROM KUNDENTABLE WHERE KD_HASH <>''
> =4999
> 
> SELECT * FROM KUNDENTABLE,KUNDENKARTENTABLE WHERE KD_HASH <>'' AND
> CRD_KD_ID=KD_ID
> =5129
> 
> How can this be possible? As far as I see, there are no doubles in the list.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]