[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