Re: Re: SQL JOINs vs WHERE statements

[bean]

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

Left outer join:

table1.column1 (+) = table2.column2

Right outer join:

table1.column1 = table2.column2 (+)

Full outer join:

table1.column1 (+) = table2.column2 (+)

Inner join:

table1.column1 = table2.column2

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

[glwtta]

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.