Re: Queries give impossible results

From: Jake S <nospam_at_nospam.net>
Date: Fri, 15 Nov 2002 09:58:46 GMT
Message-ID: <qz3B9.125$Ph.4851@read2.inet.fi>

>
> The two groups above can each have many, many members. But there may
> be only a few members (the xxxx) that belong to both groups ( the
> "and" operator in your case).
>

You're completely right but e.g. use calculator and you understand. You just didn' read the example carefully enough. When I said we are not beginners I meant that.

By common sense I meant that if there are 10 customers in a database and 8 of them are 'ACTIVE' and 8 of them <> 'PERSON' that means that there must be more than 1 customers that are both 'ACTIVE' AND <> 'PERSON'. Both columns has NOT NULL constraint.

This is just a basic example, please don't argue with other possibilities, I understand.

001 NOTACTIVE 'PERSON'
002 NOTACTIVE 'PERSON'
003 ACTIVE 'NOTPERSON'
004 ACTIVE 'NOTPERSON'
005 ACTIVE 'PERSON'
006 ACTIVE 'PERSON'
007 ACTIVE 'PERSON'
008 ACTIVE 'PERSON'

009 ACTIVE 'PERSON'
010 ACTIVE 'PERSON' My mistake was to post the simpliest possible example at the first place.

And we haven't figured this out yet. First we thought this might be an index problem but it's not. Now I'm trying to figure out what kind of a character set problem might cause this. Refer to my other posts to see what I mean.

• Jake -

Received on Fri Nov 15 2002 - 03:58:46 CST