Hypersonic and "Having" sql clause

[kaikunze]

I use a freeware db vis tool to disply the contents of a test database. If I include a "Having" in an sql statement running Hypersonic I get always an error back. If I use the same statement with sapdb it works perfectly.
Anybody a clue why??? Is the "Having" statement not implemented for Hypersonic???

[peter_f]

Hypersonic SQL currently supports the following SQL statements and syntax:

Alphabetical list:

CALL
CHECKPOINT
COMMIT
CONNECT
CREATE ALIAS
CREATE INDEX
CREATE TABLE
CREATE USER
DELETE
DISCONNECT
DROP INDEX
DROP TABLE
DROP USER
GRANT
INSERT
REVOKE
ROLLBACK
SCRIPT
SELECT
SET AUTOCOMMIT
SET IGNORECASE
SET LOGSIZE
SET PASSWORD
SET REFERENTIAL_INTEGRITY
SET WRITE_DELAY
SHUTDOWN
UPDATE