I have 4 detachedcriteria (A, B, C, and D)

C is a subquery of A
D is a subquery of B

It would be nice to just run a query with A = B, but I don't know how to do that within 1 query, and detachedcriteria equal to eachother.

So I thought I would just say

B is a subquery of A. Can you have a subquery within a subquery?

So far it hasn't worked, and A + C works alone, B + D works alone, A + B works alone, A + C + B - D works, but when i throw them all together (A + C + (B+D)) it implodes and gives me a NPE and doesn't show me the sql for it.

seems that subqueries can go only one level deep: http://www.nabble.com/Querying-Associations-to11771664.html#a11771664

From the outside view it doesn't look all that hard to say just make it recursive, but maybe it is.

Think I might solve this through filtered mapping files.