result differences due to joins?

[Florian Bogeschdorfer]

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net [mailto:valentina-
> bounces at lists.macserve.net] On Behalf Of Ruslan Zasukhin
> Sent: Wednesday, July 26, 2006 4:50 PM
> To: valentina at lists.macserve.net
> Subject: Re: result differences due to joins?
> 
> On 7/26/06 4:29 PM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:
> 
> Hi Florian,
> 
> I think REINDEX can help

Hi Ruslan. I reindexed the database 2 weeks ago because some KD_ID s could
not be found. Can it be necessary again (took 1 hour with 18000 records)?

Florian

> 
> > 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]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina