SQL WITH doesn't work

[dwstanton]

Hi.
I’m forming a complex query and wish to use the following as the start point:

WITH SELECTED AS (
Select “Amount” as AMOUNT, MONTH(“Date”) * 100 + DAY(“Date”) as MODY, YEAR(“Date”) * 100 + MONTH(“Date”) as YRMO
FROM “Tbl-Donations” where “Date” IS NOT NULL ORDER BY “Date”)
SELECT * FROM SELECTED

After many frustrating days and nights I’m unable to find anything anywhere to help me.
Please advise.
Thanks

[peterwt]

I assume you are using HSQLDB embedded database. It seems that the WITH clause is not supported by HSQLDB. The SQL commands in HSQLDB are shown at http://www.hsqldb.org/doc/guide/ch09.html.