1. SQL Reference Guide
  2. SQL Query Management
  3. Joins
  4. Left Outer Join (LOJ)
  5. Nested tables Vs LOJ

Nested tables Vs LOJ

To query multiple tables in the same hierarchy, you can also use the NESTED TABLES clause. To get more details about Nested tables and using it to join a parent table with its child table, see Using NESTED TABLES clause to query multiple tables in the same hierarchy

Table 6-8 Nested Tables Vs LOJ

Nested Tables LOJ
Queries multiple tables in the same hierarchy Queries multiple tables in the same hierarchy
Not an ANSI-SQL Standard ANSI-SQL Standard
Supports sibling tables join Does not support sibling table joins