The first query does not need a join either, since the correct SQL uses a subquery. I am not quite sure what issue to open for the JPA spec, because I think the spec clearly states to support this. Do you mean I should open an issue there to ask who of us is correct? |