The JCR 2.0 specification does include joins in the standard JCR-SQL2 grammar, though the only defined types of joins included inner, left outer, and right outer joins. Because SQL also defines the useful full outer and cross join types, ModeShape adds support for these.