in reply to Re: SQL JOINs vs WHERE statements
in thread SQL JOINs vs WHERE statements

There is nothing silly or unusual about the left outer join in Oracle 8.

Left outer join: 
table1.column1 (+) = table2.column2

[download]
Right outer join: 
table1.column1 = table2.column2 (+)

[download]
Full outer join: 
table1.column1 (+) = table2.column2 (+)

[download]
Inner join: 
table1.column1 = table2.column2

[download]
It isn't the *= syntax, but it is consistent and logical.

Replies are listed 'Best First'.
Re: Re: Re: SQL JOINs vs WHERE statements
by glwtta (Hermit) on Aug 18, 2003 at 20:48 UTC
    Yeah, from what I remember I didn't know about the (+) syntax at the time, and what someone at work showed me was a UNION of an inner join with the values of a "null join" which would give you the rows that didn't join with the second table. Still weird, but not Oracle's fault :) In any case, I haven't done much with Oracle 8 and still know little about it.
[reply]

In Section Seekers of Perl Wisdom