You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@jackrabbit.apache.org by Gadbury <ga...@googlemail.com> on 2010/04/28 12:33:36 UTC

JCR SQL2 query - are subselects allowed?

Hi all,

Is it possible to do a sub-select such as the following?

select a from x inner join (select w from y) as z on b = w
-- 
View this message in context: http://jackrabbit.510166.n4.nabble.com/JCR-SQL2-query-are-subselects-allowed-tp2068932p2068932.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.

Re: JCR SQL2 query - are subselects allowed?

Posted by Thomas Müller <th...@day.com>.

Hi,

No, this is not supported. See also http://www.h2database.com/jcr/grammar.html

Regards,
Thomas