Reported By: Elevate Software Reported On: 1/25/2002 For: Version 3.04 Build 1
# 1012Using COUNT(*) in a HAVING Clause Results in a Type Mismatch Error Using COUNT(*) in a HAVING clause of an SQL SELECT statement results in a "type mismatch" SQL error, even though this is perfectly acceptable syntax.
SELECT CustNo, COUNT(*)
FROM Orders
GROUP BY 1
HAVING COUNT(*) > 0
ResolutionFixed Problem on 1/23/2002 in version 3.05 build 1