Count Query not Returning

[petperson]

I'm trying to get a count of households where there is not a Head of household defined. There are different account types for different members of a household - but there should only be one head of household. Please help!

My query is set up like:

SELECT HH,
COUNT(HH) NumOccur
FROM HHOLDS
where account_type = 'HEAD'
GROUP BY HH
HAVING ( COUNT(HH) = 0 )

 

[r937]

SELECT hh
     , SUM(CASE WHEN account_type = 'HEAD'
                THEN 1 ELSE 0 END ) AS NumOccur 
  FROM hholds
GROUP 
    BY hh
HAVING NumOccur = 0

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon