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#4049915 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4049915 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
