[thelist] Won't return results for 0 matches

CDitty mail at redhotsweeps.com
Tue Jul 18 13:30:13 CDT 2000


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





More information about the thelist mailing list