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