A JCR-SQL2 join that uses a REFERENCE property in the join clause returns 0 records, even when it should return some records. A good test case is given in the forum.

Unfortunately, no workaround exists.