Ask Your Question
0

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
0

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 http://www.hsqldb.org/doc/guide/ch09.....

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 56 times

Last updated: Apr 28 '16