Is it possible to perform an outer join between two entities that have similar columns but do not share a relationship?
I found this example from Hibernate doumentation which returns multiple objects, but not quite what I am looking for.
Iterator results = em.createQuery(
"select cat.color, min(cat.birthdate), count(cat) from Cat cat " +
"group by cat.color")
.getResultList()
.iterator();