result differences due to joins?

[Ruslan Zasukhin]

On 7/27/06 11:59 AM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:

Hi Florian,

> I reindexed, still the same result. Maybe I should also say that it is a 1
> to many relation.

Okay, lets look deeply

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


We have inner join..

4999 - this is number of records?
So join give more records than left table ?

Have join by recID + ObjectPtr ?

Have you simply check join table result to see that EXTRA records ?
May be some LEFT records are shown few times ?


-- 
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]