}).validate(query, query.execute());
queryString = "SELECT relationship.[test:target], target.[jcr:path] "
+ " FROM [test:relationship] AS relationship "
+ " JOIN [test:node] AS target ON relationship.[test:target] = target.[jcr:uuid] ";
query = queryManager.createQuery(queryString, Query.JCR_SQL2);
validateQuery().rowCount(2).validate(query, query.execute());
queryString = "SELECT node.[jcr:path], relationship.[test:target], target.[jcr:path] FROM [test:node] AS node "
+ " JOIN [test:relationship] AS relationship ON ISCHILDNODE(relationship, node) "
+ " JOIN [test:node] AS target ON relationship.[test:target] = target.[jcr:uuid] "