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
I need this too...