result differences due to joins?

[Florian Bogeschdorfer]

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.


TIA

Florian Bogeschdorfer