Syntax Error In Sql Statement “with” Keyword Throwing Exception

I have also added another TMP2 and was not able to run the query... Could you please help me on this query? I am using Oracle 11g. WITH TMP1(REQUEST_NO) AS (SELECT REQUEST_NO FROM

Solution 1:

Oracle supports the WITH clause, but it is looks like H2 does not support it: H2 SQL grammar

I would transform the query in the with part to the main query.