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

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#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...