0 Replies Latest reply on May 26, 2002 9:21 PM by Robson

    Outer joins in EJB-QL?

    Robson Newbie


      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?