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:18:03 EDT