Previous Next JavaScript must be enabled to correctly display this content

## 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-9 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