0 Replies Latest reply on Jan 15, 2008 12:52 AM by mcronin

    JPA outer join on unrelated tables

    mcronin Newbie

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