ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.


AddThis Social Bookmark Button
  More on JOINS
Subject:   Outer Joins With Oracle
Date:   2001-09-07 12:43:30
From:   boyd4715
I Believe that the *= is non ansi standard on doing joins. Oracle uses (+). This is place next to the column. So

a.foo = b.foo(+) would do a left outer join
a.foo(+) = b.foo woudl do a right outer join

1 to 1 of 1
1 to 1 of 1