1 Reply Latest reply on Jun 13, 2005 12:40 PM by rpa_rio

    Joining multiple EJBs

    Johhny Blayze Newbie

      Hi, I was wondering is there a way I can JOIN multiple EJBs on a particular field using EJB-QL and/or JBoss-QL without manually setting up the relationships ?

      Ie, something that mimicks,

      Select p.FName, s.Name, d.districtID
      FROM Person p INNER JOIN School s ON p.schoolID = s.schoolID INNER
      JOIN District d ON s.districtID = d.districtID
      WHERE p.schoolID = s.schoolID AND s.districtID = d.districtID

      OR

      Select p.FName, s.Name, d.districtID
      FROM Person p, School s, District d
      WHERE p.schoolID = s.schoolID AND s.districtID = d.districtID