SELECT ...
FROM DOCUMENTS d
LEFT JOIN DICTIONARIES d1 ON (d.dict1_id = d1.dict_id)
WHERE d1.dict_status = 1 AND d1.dict_locale = :param
should be morally equivalent. It's usually a bad idea to put filtering predicates in
join predicates in SQL; I can't imagine it being any better for EJBQL.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4049915#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...