NATURALINNERJOIN – creates new table from common rows of two tables
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).