Hi, Actually, it should be able to expand the "*". What version of jackrabbit are you using?
See [0], [1] for some examples of SQL2 joins. best, alex [0] http://svn.apache.org/repos/asf/jackrabbit/trunk/jackrabbit-core/src/test/java/org/apache/jackrabbit/core/query/JoinTest.java [1] http://svn.apache.org/repos/asf/jackrabbit/trunk/jackrabbit-core/src/test/java/org/apache/jackrabbit/core/query/SQL2OuterJoinTest.java On Tue, Nov 1, 2011 at 7:23 PM, Jukka Zitting <[email protected]>wrote: > Hi, > > On Tue, Nov 1, 2011 at 7:01 PM, jsmarks <[email protected]> wrote: > > select * from [nt:folder] as fo left outer join [nt:file] as fi on > > isdescendantnode(fi, fo) > > > > the error is "This query result contains more than one selector". Trying > fo > > or fi in place of * tells me I need to supply a selector name. > > Use "fo.*", "fi.*" or "fo.*, fi.*" instead of "*". > > I guess we should make the query parser automatically expand "*" to > all the properties of all the selectors, but until that's done you > need to explicitly list the selectors from which you want results. > > BR, > > Jukka Zitting >
