The NATURALINNERJOIN creates tables, using rows from original tables, that are present in both of them.

Let´s have these two tables. Some values of key are common (green), some of them are in one table only (red).

Tables are connected by a relationship:

The NATURALINNERJOIN creates table, showing columns from both tables. It only shows rows, that are common for both original tables (green ones).