Re: OUTER/INNER JOIN Syntax

Sri wrote:

> 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

No.

Daniel Morgan Received on Wed Jun 12 2002 - 10:07:12 CDT