Reported By: Robert Kaplan Reported On: 2/28/2001 For: Version 2.06 Build 1
# 728Using a Column Name in SQL HAVING Clause When Column Is Aliased Causes AV The following SQL generates an AV. If the column alias is used instead of the column name it works.
SELECT U_ID, SUM(DL_AMT) DOLLAMT, U_CURRBAL CURRBAL
FROM DOLLS, UNITS
WHERE (U_ID=DL_UNIT)
GROUP BY U_ID
HAVING DOLLAMT < > U_CURRBAL
ResolutionFixed Problem on 2/28/2001 in version 2.07 build 1