Re: Translating outer joins

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Aug 17 2006 - 17:20:41 EDT

  • Next message: Mike Kienenberger: "Debugging unit tests"

    Yes, actually there was some discussion before to use such syntax for
    the inner joins as well. I am all for it (I guess we have to preserve
    a backdoor for the old syntax in case some db does not support such
    syntax).

    Andrus

    On Aug 17, 2006, at 5:17 PM, Mike Kienenberger wrote:

    > Even better link
    >
    > http://www.devx.com/dbzone/Article/17403/0/page/3
    >
    > Looks like we do away with WHERE clause joins altogether (at least for
    > Oracle) and explicly join everything with ON statements.
    >
    > On 8/17/06, Mike Kienenberger <mkienen..mail.com> wrote:
    >> This is somewhat helpful for the various kinds of joins.
    >>
    >> http://www.praetoriate.com/oracle_tips_outer_joins.htm
    >>
    >> Still looking for complex examples.
    >>
    >> On 8/17/06, Mike Kienenberger <mkienen..mail.com> wrote:
    >> > On 8/17/06, Andrus Adamchik <andru..bjectstyle.org> wrote:
    >> > > It would be nice if we could implement the translator using
    >> standard
    >> > > SQL syntax ("left outer join" instead of "(+)"), as it will
    >> work on
    >> > > most DB's including Oracle (starting from 9i), while the "(+)"
    >> syntax
    >> > > only works on Oracle (and is probably considered legacy syntax by
    >> > > Oracle too).
    >> > >
    >> > > select
    >> > > name,
    >> > > department_name
    >> > > from
    >> > > employees e
    >> > > left outer join
    >> > > departments d
    >> > > on
    >> > > e.department_id = d.department_id;
    >> > >
    >> > > It will be somewhat harder to implement, but will solve the issue
    >> > > once and for all.
    >> >
    >> > Well, sure, now you tell me :-)
    >> >
    >> > My Oracle Reference Book is Oracle8, so I didn't realize we had a
    >> > better choice :-)
    >> >
    >> > I guess I need to see if I can find some documentation on this
    >> format.
    >> >
    >> > The simple example is obvious, but what does it look like with more
    >> > tables involved, some with more outer joins and some without?
    >> >
    >>
    >



    This archive was generated by hypermail 2.0.0 : Thu Aug 17 2006 - 17:21:08 EDT