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