Women in Technology

Hear us Roar

  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

Main Topics Newest First

Showing messages 1 through 1 of 1.

  • Outer Joins With Oracle
    2004-04-15 01:43:31  juby [View]

    outer joins