This content has been marked as final.
Show 2 replies
-
1. Re: Missing join in SQL query with EJB-QL ORDER BY clause (j
wolfc Jun 1, 2004 9:20 AM (in response to wolfc)As a workaround I did:
SELECT OBJECT(fr) FROM Film f, FilmRental fr, Principal p WHERE p.id = ?1 AND fr.location MEMBER OF p.locations AND fr.year = ?2 AND fr.week = ?3 AND fr.film = f ORDER BY f.name ASC -
2. Re: Missing join in SQL query with EJB-QL ORDER BY clause (j
aloubyansky Jun 1, 2004 2:37 PM (in response to wolfc)Yes, it's a bug. You also can see that t8_fr_film.film_name is included in the select. It was fixed in later versions. Can you try 3.2.4 or 3.2.3?