HAVING SYNTAX
Posted: Fri May 15, 2009 10:48 am
I see nothing wrong with this query, but Texis gives me the error "Field $star non-existent" (Well, I know that!!!). What am I doing wrong:
SELECT PATN_WKU, COUNT(*)
FROM PATN
WHERE PATN_ISD = '20030520'
GROUP BY PATN_WKU
HAVING COUNT(*) > 1
ORDER BY 2;
Also, can someone point me to documentation on the use of HAVING in Texis SQL.
SELECT PATN_WKU, COUNT(*)
FROM PATN
WHERE PATN_ISD = '20030520'
GROUP BY PATN_WKU
HAVING COUNT(*) > 1
ORDER BY 2;
Also, can someone point me to documentation on the use of HAVING in Texis SQL.