Using inner join with parent-child tables

A Join is used to combine rows from two or more tables, based on related columns or fields between them. In a hierarchical table, the child table inherits the primary key columns of its parent table. This is done implicitly, without including the parent columns in the CREATE TABLE statement of the child. All tables in the hierarchy have the same shard key columns.

An inner join is one of the types of join used to combine tables that belong to the same table hierarchy in an Oracle NoSQL Database.

• Overview of Inner Join
• Examples using Inner Join