Re: LEFT and RIGHT OUTER JOINs in Oracle SQL?

SELECT bli, bla, blub
FROM t_driving dr, t_possibly_not_corresponding pnc WHERE dr.attr = pnc.attr (+);

On Sun, 9 Dec 2001 14:59:26 +0200, "Roger Abercombie" <rab_at_spambegone.be> wrote:

>Hello,
>
>I'm a newcomer to the Oracle environment.
>
>A noticeable absense in Oracle SQL is the lack of the SQL-standard
>LEFT and RIGHT OUTER JOIN clauses (unless I misread the
>documentation :-) Could anybody offer any 'standard' or
>cookbook syntax for replacing these clauses when developing
>for Oracle?
>
>Thanks!
>
>
>
>
>

regards
Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de Received on Sun Dec 09 2001 - 07:30:10 CST