Performing Outer Joins Using SQL/92 : Outer Join SQL 92 Syntax « Table Joins « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Table Joins
  3. Outer Join SQL 92 Syntax

SQL/92 uses a different syntax for performing outer joins.

Instead of using (+), you specify the type of join in the FROM clause of your SELECT statement using the following syntax:

FROM table1 { LEFT | RIGHT | FULL } OUTER JOIN table2

where

  1. table1 and table2 specify the tables that you want to join.
  2. LEFT specifies you want to perform a left outer join.
  3. RIGHT specifies you want to perform a right outer join.
  4. FULL specifies you want to perform a full outer join;

A full outer join uses all rows in table1 and table2 including those that have null values in the columns used in the join.

You can't directly perform a full outer join using the (+) operator.

Quote from:

Oracle Database 10g SQL (Osborne ORACLE Press Series) (Paperback)

# Paperback: 608 pages

# Publisher: McGraw-Hill Osborne Media; 1st edition (February 20, 2004)

# Language: English

# ISBN-10: 0072229810

# ISBN-13: 978-0072229813

7.10.Outer Join SQL 92 Syntax
7.10.1.Performing Outer Joins Using SQL/92
7.10.2.Performing Left Outer Joins Using SQL/92
7.10.3.Performing Right Outer Joins Using SQL/92
7.10.4.Performing Full Outer Joins Using SQL/92