Re: Queries give impossible results

> The example you have given is entirely possible as you are attempting to
> compare oranges and apples (customer_state and customer_type).
>

Please, read the example more carefully. Using common sense it's easy to understand that customers that there are more than 4 customers that are not 'PERSON' but are 'ACTIVE'. I'm not a beginner with databases nor SQL and there are more people in my company that are puzzled with this problem. I don't post unnecessary messages. This is a cry for help.

> Have you a more concrete example of the data to show the count is wrong?
>

Unfortunately I cannot do that. This is a production database.

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

• Jake -