On 2014-03-31 17:57, SARAVANAMANI S wrote:
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


Sorry, we only support a single recursive query.

--
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.

Reply via email to