In a Database Management System (DBMS), a **natural join** is a type of join operation that combines rows from two or more tables based on their common columns. A natural join automatically matches columns with the same name and compatible data types from each table involved in the join. It eliminates duplicate columns from the result, retaining only one instance of each of the common columns.
### Syntax
The syntax for a natural join in SQL is


