2 Replies Latest reply on Jul 13, 2009 2:21 PM by Prathamesh Gaddam

    How To: OUTER JOINS ?

    Prathamesh Gaddam Novice
      Dear Team,

      I guess RESTRICTION in EntityQuery makes INNER JOIN.

      1. So is there any way for OUTER LEFT/RIGHT JOIN using RESTRICTIONS?

      2. Any way to add RESTRICTION between multiple JOINS?

      e.g I need to convert SQL to EJBQL using EntityQuery, from:
      "
      from     issues right outer join issue_status
                on issues.status = issue_status.id
      and               issues.created_by='loggedInUser'          
                left outer join issue_priority
                on issues.priority = issue_priority.id"