Hey Marina,
Thank you! This actually worked. There was one strange "ghost" join to EMP in the resulting SQL, but that's a small price to pay for the fact that the JPQL query is actually possible.
TopLink Essentials 2.0 (Build b58b-rc3) produced the following SQL:
[pre]
SELECT t0.NAME, t1.NAME
FROM EMP t3, EMP_FULL_TIME t2, EMP t1, DEPT t0
WHERE (((t1.ID = t3.ID) AND (t2.SALARY > ?)) AND
((t3.DEPT_ID = t0.ID) AND ((t2.ID = t1.ID) AND (t1.EMP_TYPE = ?))))
[/pre]
It seems I have to read some more about JPQL queries.
Best regards,
Bisser
[Message sent by forum member 'bisser' (bisser)]
http://forums.java.net/jive/thread.jspa?messageID=232392