Re: LEFT and RIGHT OUTER JOINs in Oracle SQL?

"Roger Abercombie" <rab_at_spambegone.be> wrote in message news:3c1361be_4_at_news2.prserv.net...
> 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!
>
>
>
>
>

Before you repeat your ramble about *the* standard: there is no such thing. the SQL92 standard has several levels, most vendors -including Oraclecomply  with the lowest level. Only Sybase, and it's derivatives (as you could expect Microsux didn't 'invent' Sqlserver) choose to comply to a higher level.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address