Hi,
I have to do a query like (in SQL)
SELECT DISTINCT course_id FROM T_Course AS c LEFT JOIN T_User_Course AS uc ON c.course_id = uc.course_id LEFT JOIN T_User AS u ON uc.user_id = u.user_id AND u.user_id = ?1 WHERE (uc.confirmation_date IS NULL)
There is some way to do this in EJB-QL?
Robson.