OUTER/INNER JOIN Syntax

From: Sri <skuniset_at_yahoo.com>
Date: 11 Jun 2002 17:21:55 -0700
Message-ID: <c630a3dd.0206111621.382f97af@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 - 19:21:55 CDT