Re: SQL JOIN ?

Schauder <Jens.Schauder_at_opal-edv.com> wrote in article <893676718.829597_at_demdwu29>...
> The syntax of joins is different in Oracle ( It's all in the where
clauses).
> It works like this:
>
> select TableA.a, TableB.b
> from TableA, TableB
> where TableA.key = TableB.key
> and ... -- Any other constraints.
>
> this will do an inner join.
> to get an outer join use (+) at one side
> of the join:
>
> select TableA.a, TableB.b
> from TableA, TableB
> where TableA.key = TableB.key(+)
> and ... -- Any other constraints.
>
> gets also the set with TableA.key equal to null. (might be the other way
> round)

I think it is the other way around. The side with the (+) is where the nulls would occur, I think.

--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com Received on Mon Apr 27 1998 - 15:05:31 CDT