[jboss-user] [EJB 3.0] - Re: ejb-ql relations/mapping problem

[ojacobson]

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