Ask Your Question

SQL WITH doesn't work.

asked 2016-04-28 10:36:53 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-04-28 12:23:01 +0200

peterwt gravatar image

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-04-28 10:36:53 +0200

Seen: 56 times

Last updated: Apr 28 '16