Won't return results for 0 matches
| From: | CDitty | Date: | Tue, 18 Jul 2000 18:11:55 +0000 |
| Subject: | Won't return results for 0 matches | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-7115@lists.php.net to get a copy of this message | ||
Does anyone see anything wrong with this statement as to why it won't return those that didn't match? It works for 1-whatever, but not for 0. I have physically verified that there are a few entries that have 0 matches in them.
select count(pick) as cnt, ticket
from archivepicks
where pick IN (11, 24, 29, 41, 49, 52)
group by ticket
having count(pick) = 0";
Any help is appreciated.
Thanks
CDitty