Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: OUTER/INNER JOIN Syntax
Only in 9i
"Sri" <skuniset_at_yahoo.com> wrote in message
news:c630a3dd.0206111621.382f97af_at_posting.google.com...
> Does Oracle 8i support the ANSI syntax for OUTER JOIN and
> INNER JOIN? I know that 9i supports it, but not sure about 8i.
>
> For example, ANSI Syntax for OUTER JOIN is:
> SELECT *
> FROM A LEFT OUTER JOIN B ON A.x = B.x
> WHERE...
>
> For example, ANSI Syntax for INNER JOIN is:
> SELECT *
> FROM A INNER JOIN B ON A.x = B.x
> WHERE...
>
>
> You can use "(+)" syntax to do the outer join in Oracle 8i,
> but I would like to use the ANSI syntax.
>
> Thank You.
> -Sri
Received on Tue Jun 11 2002 - 20:59:21 CDT