Query query = entityManager.createQuery("FROM " + User.class.getSimpleName()
                                                + " cu LEFT JOIN FETCH 
cu.userSurveys us"
                                                + " WHERE cu.purchaseDate <= 
:purchaseDate"
                                                + " AND NOT EXISTS (SELECT us 
FROM cu.userSurveys us WHERE us.userId = cu.userId)");

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4083872#4083872

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4083872
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to