[jboss-user] [EJB 3.0] - JPA outer join on unrelated tables

mcronin do-not-reply at jboss.com
Tue Jan 15 00:52:35 EST 2008


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();




View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4119900#4119900

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4119900



More information about the jboss-user mailing list