Apache Derby - Does it support 'WITH'

Viewed 798

Couldn't find anything on the Internet for this at all and wondered if someone could help me.

Using Apache Derby with a query in a Spring Boot app:

The query starts like this:

WITH dbName AS {
    (Then goes on to select data from tables)
}

When running my test cases I get an exception which reads:

java.sql.SQLSyntaxErrorException: Syntax error: Encountered "with" at line 1, column 1

Does Apache Derby support WITH? I can't see any other reason why this shouldn't work.

1 Answers
Related