result differences due to joins?

[Sims, John (CDC/CCHP/NCBDDD) (CTR)]

Florian said
> >>> 
> >>> 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?
> >> 

Hi Florian,

I think a better check of this data would be to check these 2 queries:

SELECT * FROM KUNDENTABLE,KUNDENKARTENTABLE WHERE KD_HASH <>''

versus

SELECT * FROM KUNDENTABLE,KUNDENKARTENTABLE WHERE KD_HASH <>'' AND
CRD_KD_ID=KD_ID

How many records to these return?

-John