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






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

With the introduction of Oracle9i, the database also implements the ANSI SQL/92 standard syntax for joins.

To make your SQL fully compliant with the new standard, you should use SQL/92 in your queries.

7.9.SQL 92 Syntax
7.9.1.Performing Joins Using the SQL/92 Syntax
7.9.2.Performing Inner Joins on Multiple Columns Using SQL/92
7.9.3.Performing Inner Joins on Two Tables Using SQL/92, on clause