Re: inner or outer join?

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Tue Jan 26 2010 - 06:07:44 EST

  • Next message: Andrey Razumovsky: "Re: inner or outer join?"

    We had an offline conversation about that with Ksenia. I should
    clarify that we are talking about EJBQL "SELECT" clause. As in
    "SELECT p.artist FROM Painting p"

    Andrus

    On Jan 26, 2010, at 12:35 PM, Khailenka Xenia wrote:

    > There is a question which join strategy would be better to use
    > implicitly
    > when supporting the relationship with the other entity - inner or
    > outer. On
    > the one hand, the inner join allow to avoid entities with null
    > references
    > when we want to restrict the result set, on the other hand we can
    > lose these
    > entities when we not care about those references. Now the outer join
    > is
    > implicitly used and that results in ability to get the null entity
    > at the
    > result set. Any thoughts?
    >
    > --
    > Regards, Ksenia Khailenko

    This archive was generated by hypermail 2.0.0 : Tue Jan 26 2010 - 06:08:18 EST