Hi Noel, Thank you for your response. We did modified the query to recursive like WITH x(n) as (select n from t1) select n from x then it started working fine but if we include one more select statement it fails again.
Query: WITH x(n) as (select n from t1), y(m) as (select m from t2) select m from y Error: org.h2.jdbc.JdbcSQLException:Syntax error in SQL statement "WITH X(N) AS (SELECT N FROM T1), [*]Y(M) AS (SELECT M FROM T2) SELECT M FROM Y"; expected "(, SELECT, FROM"; SQL statement: Please suggest us how to resolve this issue. Thanks! On Monday, March 31, 2014 7:06:44 AM UTC-7, Noel Grandin wrote: > > > > On 2014-03-27 23:57, Anteneh Mamo wrote: > > when we try to run the sql statement : *WITH TMP1 AS (SELECT col1 FROM > table1) SELECT TMP1.col1 FROM TMP1*. we are > > getting the below exception > > > At the moment we only support recursive with statements > i.e. WITH X(N) > so you'll have to rewrite that using a normal joib. > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
