Re: Queries give impossible results

From: Chuck <chuckh_at_softhome.net>
Date: 14 Nov 2002 14:39:06 GMT
Message-ID: <Xns92C6622F2706Dchuckhsofthomenet@130.133.1.4>

"Jake S" <nospam_at_nospam.net> wrote in
news:kyMA9.182$ZR5.5926_at_read2.inet.fi:

>> > Have you done a select * instead of a select count(*) and got more
>> > than 

> 4

>> > records in your final example?
>> >
>>
>> Yes I have. I've also tried all the possible combinations with this
>> query. 
>>

>
> The answer was: yes, I've done that and no, I only get 4. I'm thinking
> that indexes might be the problem.
>
> - Jake -
>
>

Just for fun, try putting a /*+ full(ci_customer) */ hint on the query. If an index is indeed that problem this should give you the correct result.

Do both columns have NOT NULL constraints on them? Received on Thu Nov 14 2002 - 08:39:06 CST